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 vikrey...@gmail.com 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

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-07 Thread Chetan Suttraway
On Tue, Feb 7, 2012 at 5:44 PM, Kevin Grittner kevin.gritt...@wicourts.govwrote: 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

[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

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 kevin.gritt...@wicourts.govwrote: Chetan Suttraway chetan.suttra...@enterprisedb.com wrote: This is regarding the TODO item: Prevent the specification of conflicting transaction read/write options listed at: http://wiki.postgresql.org

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-07 Thread Chetan Suttraway
On Wed, Feb 8, 2012 at 8:15 AM, Robert Haas robertmh...@gmail.com wrote: On Tue, Feb 7, 2012 at 4:25 PM, Peter Eisentraut pete...@gmx.net 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 typemod from

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 robertmh...@gmail.com wrote: On Tue, Feb 7, 2012 at 4:25 PM, Peter Eisentraut pete...@gmx.net wrote: On ons, 2012-02-01 at 15:53 +0530, Chetan Suttraway

Re: [HACKERS] patch for implementing SPI_gettypemod()

2012-02-06 Thread Chetan Suttraway
On Thu, Feb 2, 2012 at 8:11 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Feb 1, 2012 at 5:23 AM, Chetan Suttraway chetan.suttra...@enterprisedb.com wrote: Hi All, This is regarding the TODO item : Add SPI_gettypmod() to return a field's typemod from a TupleDesc The related

[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

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 mag...@hagander.netwrote: On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway chetan.suttra...@enterprisedb.com wrote: Hi, I am trying to install postgres 8.4.3.1 on windows machine which has chinese locale. The install wizard throws

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 j...@agliodbs.com wrote: On 1/6/10 9:13 AM, Robert Haas wrote: On Wed, Jan 6, 2010 at 12:06 PM, David

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