Re: [HACKERS] Scaling shared buffer eviction

2014-09-03 Thread Mark Kirkwood
On 03/09/14 16:22, Amit Kapila wrote: On Wed, Sep 3, 2014 at 9:45 AM, Amit Kapila wrote: On Thu, Aug 28, 2014 at 4:41 PM, Amit Kapila wrote: I have yet to collect data under varying loads, however I have collected performance data for 8GB shared buffers which shows reasonably good performa

Re: [HACKERS] Scaling shared buffer eviction

2014-09-03 Thread Amit Kapila
On Thu, Sep 4, 2014 at 8:00 AM, Mark Kirkwood wrote: > > > Hi Amit, > > Results look pretty good. Does it help in the read-write case too? Last time I ran the tpc-b test of pgbench (results of which are posted earlier in this thread), there doesn't seem to be any major gain for that, however for

Re: [HACKERS] vacuumdb --all --analyze-in-stages - wrong order?

2014-09-03 Thread Peter Eisentraut
On Mon, 2014-05-19 at 13:51 -0400, Peter Eisentraut wrote: > On 5/18/14, 3:52 AM, Pavel Stehule wrote: > > I am looking on --analyze-in-stages option. If I understand well, > > motivation for this option is a get some minimal statistic for databases > > in minimal time. But when I tested, I found s

Re: [HACKERS] psql \watch versus \timing

2014-09-03 Thread Fujii Masao
On Wed, Sep 3, 2014 at 11:13 PM, Fujii Masao wrote: > On Wed, Sep 3, 2014 at 10:56 PM, Greg Stark wrote: >> On Wed, Sep 3, 2014 at 12:48 PM, Michael Paquier >> wrote: >>> OK, then as all the comments are basically addressed, here is an >>> updated patch correcting the comment problems mentioned

Re: [HACKERS] psql \watch versus \timing

2014-09-03 Thread Fujii Masao
On Thu, Aug 28, 2014 at 8:46 PM, Fujii Masao wrote: > On Tue, Aug 26, 2014 at 4:55 AM, Heikki Linnakangas > wrote: >> On 08/25/2014 10:48 PM, Heikki Linnakangas wrote: >>> >>> On 08/25/2014 09:22 PM, Fujii Masao wrote: On Tue, Aug 26, 2014 at 1:34 AM, Heikki Linnakangas wrote: >>>

[HACKERS] missing tab-completion for relation options

2014-09-03 Thread Fujii Masao
Hi, Attached patch adds the missing tab-completion for the relation options like autovacuum_multixact_freeze_max_age. Regards, -- Fujii Masao *** a/src/bin/psql/tab-complete.c --- b/src/bin/psql/tab-complete.c *** *** 1694,1699 psql_completion(const char *text, int start, int e

Re: [HACKERS] PL/pgSQL 1.2

2014-09-03 Thread Pavel Stehule
2014-09-03 23:19 GMT+02:00 Hannu Krosing : > On 09/03/2014 05:09 PM, Marko Tiikkaja wrote: > > On 9/3/14 5:05 PM, Bruce Momjian wrote: > >> On Wed, Sep 3, 2014 at 07:54:09AM +0200, Pavel Stehule wrote: > >>> I am not against to improve a PL/pgSQL. And I repeat, what can be > >>> done and can > >>

Re: [HACKERS] Re: proposal: ignore null fields in not relation type composite type based constructors

2014-09-03 Thread Jeevan Chalke
Hi Pavel, You have attached wrong patch. Thanks -- Jeevan B Chalke Principal Software Engineer, Product Development EnterpriseDB Corporation The Enterprise PostgreSQL Company

Re: [HACKERS] Re: proposal: ignore null fields in not relation type composite type based constructors

2014-09-03 Thread Pavel Stehule
I am sory too much patches Regards Pavel 2014-09-04 7:35 GMT+02:00 Jeevan Chalke : > Hi Pavel, > > You have attached wrong patch. > > > Thanks > -- > Jeevan B Chalke > Principal Software Engineer, Product Development > EnterpriseDB Corporation > The Enterprise PostgreSQL Company > > commit e

Re: [HACKERS] PQputCopyEnd doesn't adhere to its API contract

2014-09-03 Thread David G Johnston
On Wed, Sep 3, 2014 at 6:25 PM, Bruce Momjian [via PostgreSQL] < ml-node+s1045698n5817646...@n5.nabble.com> wrote: > On Fri, May 9, 2014 at 12:03:36PM -0400, Robert Haas wrote: > > > On Thu, May 8, 2014 at 5:21 PM, Tom Lane <[hidden email] > >

<    1   2