Re: [HACKERS] Avoid memory leaks during ANALYZE's compute_index_stats() ?

ssage with given backend PID so it seemed to me as it's problem during backend startup - we have log_connections to on... Thanks, Kuba Dne 9.11.2010 2:04, Tom Lane napsal(a): I looked into the out-of-memory problem reported by Jakub Ouhrabka here: http://archives.postgresql.org/pgsql-

Re: [HACKERS] Problem with 8.4 stats collector high load

> This would guarantee that autovacuum is fired no later than > autovacuum_naptime after the condition for the run became true. Of course, this unfortunately not true... The guarantee is 1,5x autovacuum_naptime. But I'd be happy with it but I agree that's not what I'd as a user expect from this

Re: [HACKERS] Problem with 8.4 stats collector high load

;s highly recommend to put the stats file on ramdisk. Kuba Dne 17.2.2010 0:12, Alvaro Herrera napsal(a): Tom Lane wrote: Alvaro Herrera writes: Jakub Ouhrabka wrote: Was autovacuum requesting to write this 20MB file 650x per minute? Yes, exactly. Ideally, autovacuum would only request

Re: [HACKERS] Problem with 8.4 stats collector high load

which is set to 1s. Am I reading the code correctly? If so then 1s is not enough for big clusters. I guess it would be feasible to crank STATS_READ_DELAY up a little bit, say to 10s. What do you think? Kuba Dne 16.2.2010 19:59, Alvaro Herrera napsal(a): Jakub Ouhrabka wrote: Maybe you shou

Re: [HACKERS] Problem with 8.4 stats collector high load

way, thank you all for the quick answer and precise answers. PostgreSQL is really unique in this regard! Kuba Dne 16.2.2010 15:10, Alvaro Herrera napsal(a): Jakub Ouhrabka wrote: You might want to try setting log_autovacuum_min_duration=0 in the postgresql.conf Thanks, tried it. There is no

Re: [HACKERS] Problem with 8.4 stats collector high load

load. What's puzzling me is that there is no database activity (queries, connections) and stats collector is still eating CPU. Kuba Dne 16.2.2010 8:29, Greg Smith napsal(a): Jakub Ouhrabka wrote: I've found similar reports but with older versions of postgres: http://old.nabble.com/

[HACKERS] Problem with 8.4 stats collector high load

Hi, sorry for repost but previous message didn't get through. So I'm trying another list and sending without attachment which I can send privately upon request (strace output mentioned below). We've migrated some of our databases to 8.4 cluster (from 8.2 and older versions). These database

Re: [HACKERS] Howto change db cluster locale on-the-fly

templates 4) start the database 5) create all text/varchar user indexes Sounds this about right? I'd like to minimize downtime... How to do step 2) - change the locale?? Thanks a lot, Kuba Martijn van Oosterhout napsal(a): On Mon, Feb 19, 2007 at 09:27:06AM +0100, Jakub Ouhrabka wrote:

Re: [HACKERS] Howto change db cluster locale on-the-fly

Hi Tom, > Hacking pg_control would be the hard part; you'll never get the CRC > right if you do it manually. Possibly pg_resetxlog could be adapted > to the purpose. thanks for your valuable answer! I looked at pg_resetxlog.c but I'm no pg internals' expert - would something like this work?

[HACKERS] Howto change db cluster locale on-the-fly

Hi, we've made mistake and initdb database cluster in wrong locale :-( Now it's full of data. I've read in the docs that it's not possible to change locale. But I guess something like this would work: a) 1) drop all indexes on text/varchar columns 2) change cluster locale 3) create all index

Re: [HACKERS] How to retrieve functional index column names

;d > suggest looking in pg_depend to see which columns of the table the > index depends on. Thank you for your help Tom! Regards Jakub ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "u

Re: [HACKERS] How to retrieve functional index column names

"Tom Hebbron" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > "Jakub" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi, > > I need to retrieve the name of the function and the index column names >

[HACKERS] How to retrieve functional index column names

(pg_index.indexrelid) result? Am I wrong? Is there another way to retrieve the column names? Could anybody help me please. Regards Jakub ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Case Studio II

Hi, I use it and can recommend it. It is actively developed/maintained (the updates are free). There is very basic support of 7.3 schemas in the new version for instance... And the development team is very responsive, if you don't like or missing something write them... kuba On Sun, 2 Feb 2003 [

Re: [HACKERS] ecpg "problem" ...

hi, i think that ecpg is only text preprocessor. it doesn't understand the c semantics - it goes from the top to the end of the file row by row and sees your declaration twice. kuba On Tue, 12 Nov 2002, Marc G. Fournier wrote: > > > if (ic_flag == 1) { > /*only select those non-

[HACKERS] another optimizer question

hi, can anyone explain me why there are different query plans for "select ... from ... where y!=x" and "select ... from ... where yx" for integers, please? see the details below... thanks, kuba db_cen7=# analyze; ANALYZE db_cen7=# \d ts19 Table "ts19"