Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-02-13 Thread Chetan Suttraway
On Sun, Feb 12, 2012 at 7:36 AM, Vik Reykja wrote: > I decided to take a crack at the todo item created from the following post: > http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php > > The attached patch makes the desired changes in both code and function > naming. > > It seem

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-07 Thread Chetan Suttraway
On Wed, Feb 8, 2012 at 12:19 PM, Chetan Suttraway < chetan.suttra...@enterprisedb.com> wrote: > > > On Wed, Feb 8, 2012 at 8:15 AM, Robert Haas wrote: > >> On Tue, Feb 7, 2012 at 4:25 PM, Peter Eisentraut wrote: >> > On ons, 2012-02-01 at 15:53 +0530, Chet

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-07 Thread Chetan Suttraway
On Wed, Feb 8, 2012 at 8:15 AM, Robert Haas wrote: > On Tue, Feb 7, 2012 at 4:25 PM, Peter Eisentraut wrote: > > On ons, 2012-02-01 at 15:53 +0530, Chetan Suttraway wrote: > >> This is regarding the TODO item : > >> "Add SPI_gettypmod() to return a field's

Re: [HACKERS] patch for preventing the specification of conflicting transaction read/write options

2012-02-07 Thread Chetan Suttraway
On Tue, Feb 7, 2012 at 8:44 PM, Kevin Grittner wrote: > Chetan Suttraway wrote: > > > This is regarding the TODO item: > > "Prevent the specification of conflicting transaction read/write > > options" > > > > listed at: > > http://wiki.post

[HACKERS] patch for preventing the specification of conflicting transaction read/write options

2012-02-07 Thread Chetan Suttraway
Hi, This is regarding the TODO item: "Prevent the specification of conflicting transaction read/write options" listed at: http://wiki.postgresql.org/wiki/Todo The issue is : SET TRANSACTION read only read write read only; The fix involved iteration over transaction_mode_list and checking for d

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-07 Thread Chetan Suttraway
On Tue, Feb 7, 2012 at 5:44 PM, Kevin Grittner wrote: > "Kevin Grittner" wrote: > > > moved this to "Replication and Recovery" > > Oh, that was a different patch -- I didn't see yours. > > (It's early, and the caffeine isn't working yet.) > > Anyway, you should have plenty of options now. > > -Ke

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-06 Thread Chetan Suttraway
On Thu, Feb 2, 2012 at 8:11 PM, Robert Haas wrote: > On Wed, Feb 1, 2012 at 5:23 AM, Chetan Suttraway > wrote: > > Hi All, > > > > This is regarding the TODO item : > > "Add SPI_gettypmod() to return a field's typemod from a TupleDesc&q

[HACKERS] patch for implementing SPI_gettypemod()

2012-02-01 Thread Chetan Suttraway
Hi All, This is regarding the TODO item : "Add SPI_gettypmod() to return a field's typemod from a TupleDesc" The related message is: http://archives.postgresql.org/pgsql-hackers/2005-11/msg00250.php This basically talks about having an SPI_gettypemod() which returns the typmod of a field of tupd

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-01-11 Thread Chetan Suttraway
On Wed, Jan 11, 2012 at 5:13 PM, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > Hi, > After running regression, I ran EXPLAIN on one of the queries in > regression (test create_misc) and got following output > regression=# explain verbose select * into table ramp from road where name >

Re: [HACKERS] initdb failing for chinese locale on windows machine

2010-04-13 Thread Chetan Suttraway
On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander wrote: > On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway > wrote: > > Hi, > > > > I am trying to install postgres 8.4.3.1 on windows machine which has > > chinese locale. > > The install wizard throws warnin

Re: [HACKERS] Auto-extending table partitions?

2010-01-07 Thread Chetan Suttraway
Adding on to this use case: what do we do when we reach end of year? Probably auto-archive as per weekly, monthly , quarterly or yearly tables? On Thu, Jan 7, 2010 at 1:14 AM, Josh Berkus wrote: > On 1/6/10 9:13 AM, Robert Haas wrote: > > On Wed, Jan 6, 2010 at 12:06 PM, David Fetter wrote: >

Re: [HACKERS] Thoughts on statistics for continuously advancing columns

2010-01-05 Thread Chetan Suttraway
Hi, My suggestion is to keep two sets of histograms. One which is generated by running ANALYZE and the other which is dynamically generated histograms using the entries from logging (that is done in insert/update/delete operations). I am not sure how difficult is it to read such record details fr