Re: copy vs. C function

From: Kevin Martyn <kevin(dot)martyn(at)enterprisedb(dot)com>
To: idc danny <idcdanny(at)yahoo(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: copy vs. C function
Date: 2011-12-14 13:14:12
Message-ID: CAPuHxPB8vpRX1rCuUQhyj14SJk7MGXm0qmigazfJPTkx=SWcrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

try
host all all 5.0.0.0/8 md5

On Wed, Dec 14, 2011 at 2:02 AM, idc danny <idcdanny(at)yahoo(dot)com> wrote:

> Hi guys,
> A nub question here since I could not figure it out on my own:
> I'm using Hamachi to connect different sites into a VPN and their address
> always starts with 5.*.*.* - the problem I'm facing is that I cannot make
> the access restricted to that particular range only.
> Currently I got :
> host all all 0.0.0.0/32 md5
> which allows all the IP's, and the try:
> host all all 5.0.0.0/32 md5
> does not work.
> So what I am suppose to add in "pg_hba.conf" in order to achieve my
> restriction? Please help me,
> Thank you,
> Danny
>
> ------------------------------
> *From:* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> *To:* Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
> *Cc:* pgsql-performance(at)postgresql(dot)org
> *Sent:* Wednesday, December 14, 2011 8:18 AM
> *Subject:* Re: [PERFORM] copy vs. C function
>
> Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> writes:
> > The only thing I have left are these statements:
>
> > get_call_result_type
> > TupleDescGetAttInMetadata
> > BuildTupleFromCStrings
> > HeapTupleGetDatum
> > and finally PG_RETURN_DATUM
>
> > It turns out that:
> > get_call_result_type adds 43 seconds [total: 54],
> > TupleDescGetAttInMetadata adds 19 seconds [total: 73],
> > BuildTypleFromCStrings accounts for 43 seconds [total: 116].
>
> > So those three functions account for 90% of the total time spent.
> > What alternatives exist? Do I have to call get_call_result_type /every
> > time/ through the function?
>
> Well, if you're concerned about performance then I think you're going
> about this in entirely the wrong way, because as far as I can tell from
> this you're converting all the field values to text and back again.
> You should be trying to keep the values in Datum format and then
> invoking heap_form_tuple. And yeah, you probably could cache the
> type information across calls.
>
> regards, tom lane
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>
>

--
Kevin P Martyn, CISSP
Principal Sales Engineer
(914) 819 8795 mobile
Kevin(dot)Martyn(at)EnterpriseDB(dot)com
Skype: kevin.martyn4

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the
individual or entity to whom it is addressed. This message contains
information from EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under applicable law. If you are
not the intended recipient or authorized to receive this for the intended
recipient, any use, dissemination, distribution, retention, archiving, or
copying of this communication is strictly prohibited. If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete this message.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2011-12-14 14:06:09 Re: copy vs. C function
Previous Message Marc Mamin 2011-12-14 10:27:10 Re: Postgres array parser