[GENERAL] Checkpoints questions

Hi list, I'm using 8.3 and I've started looking at the new checkpoint features. As a starter does anyone have some clues how to analyse this: db=# select * from pg_stat_bgwriter; checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend |

Re: [GENERAL] Checkpoints questions

Hi, Hope this helps http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Thanks DEVI.G - Original Message - From: Henrik [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Tuesday, March 04, 2008 3:28 PM Subject: [GENERAL] Checkpoints questions Hi list, I'm using

Re: [GENERAL] Checkpoints questions

On Tue, 4 Mar 2008, Henrik wrote: As a starter does anyone have some clues how to analyse this: db=# select * from pg_stat_bgwriter; checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc

Re: [GENERAL] debug nonstandard use of \\ in a string literal

Thanks guys, this simple solution worked. Why didn't I guess before?.. On Thu, Feb 28, 2008 at 2:28 PM, Albe Laurenz [EMAIL PROTECTED] wrote: Ivan Zolotukhin wrote: From time to time I face with these well-known warnings in the PostgreSQL log, i.e. Feb 28 04:21:10 db7

Re: [GENERAL] Checkpoints questions

4 mar 2008 kl. 13.45 skrev Greg Smith: On Tue, 4 Mar 2008, Henrik wrote: As a starter does anyone have some clues how to analyse this: db=# select * from pg_stat_bgwriter; checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend |

Re: [GENERAL] Build 8.3 with OpenSSL on CentOS 5.x?

On 3/4/08, Devrim GÜNDÜZ [EMAIL PROTECTED] wrote: Hi, On Tue, 2008-03-04 at 00:34 -0500, Tom Lane wrote: Karl Denninger [EMAIL PROTECTED] writes: Anyone know where the magic incantation is to find the crypto libraries? If the RPM layout is the same as Fedora (which it surely

[GENERAL] how do you write aggregate function

The help is not real clear nor can i find examples how to write an aggregate function. I searched the archive of the mail list and did not find anything I need to write Weighted Average function so the need to keep track of multiple variables between function calls is must? I see how the

Re: [GENERAL] how do you write aggregate function

Justin wrote: The help is not real clear nor can i find examples how to write an aggregate function. Examples: http://www.postgresql.org/docs/8.2/static/xaggr.html I searched the archive of the mail list and did not find anything The online documentation is excellent for these sorts of

[GENERAL] PostgreSQL Conference East, only 3 weeks left

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, There are only three weeks left to register for the PostgreSQL Community Conference: East! The conference is scheduled on March 29th and 30th (a Saturday and Sunday) at the University of Maryland. Come join us as Bruce Momjian and Joshua

[GENERAL] Benetl version 1.6

Dear all, New version (1.6) of Benetl has been released. It brings a new transformation engine (a new version the part formula). This brings much more possibilities to transform datas with the combination of several mathematics functions. This is correcting also a trouble with timestamp brought

[GENERAL] Question about PostgreSQL's bytea compatibility with MS Access as front-end

Hi, I'd really appreciate any input for this issue we've been having. I work for an environmental non-profit. We have a database that is used to store our wildlife tracking data, which includes photos of wildlife taken from the motion-detector cameras set up near Vail, CO. The database was

Re: [GENERAL] Documenting a DB schema

Shahaf Abileah wrote: I’m looking for a systematic way to document the schema for the database behind our website (www.redfin.com http://www.redfin.com/), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any

Re: [GENERAL] Documenting a DB schema

On Tuesday 04 March 2008, Shahaf Abileah [EMAIL PROTECTED] wrote: However, Postgres doesn't support the comment keyword. Is there an alternative? comment on table table_name is 'comment'; comment on column table.column_name is 'comment'; -- Alan ---(end of

[GENERAL] Documenting a DB schema

I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com http://www.redfin.com/ ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? It would be

Re: [GENERAL] Documenting a DB schema

Shahaf Abileah wrote: It would be great if the documentation could be kept as close to the code as possible – that way we stand a chance of keeping it up to date. So, in the same way that Java docs go right there on top of the class or method definitions, it would be great if I could attach

Re: [GENERAL] [SQL] Documenting a DB schema

Shahaf Abileah wrote: I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com http://www.redfin.com/), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any

Re: [GENERAL] Documenting a DB schema

Check http://www.postgresql.org/docs/8.3/interactive/sql-comment.html Cheers! Shahaf Abileah wrote: I’m looking for a systematic way to document the schema for the database behind our website (www.redfin.com http://www.redfin.com/), so that the developers using this database have a better

Re: [GENERAL] Planner: rows=1 after similar to where condition.

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joris Dobbelsteen Sent: Monday, 25 February 2008 17:08 To: Tom Lane Cc: Gregory Stark; Scott Marlowe; pgsql-general@postgresql.org Subject: Re: [GENERAL] Planner: rows=1 after similar to where condition.

Re: [GENERAL] [ADMIN] GRANT ALL ON recursive for all tables in my scheme?

A Lau [EMAIL PROTECTED] writes: I recently searched for a way to grant permissions to a new created user for all tables in a scheme or database. I just found ways who uses psql and scripts. But I'm astonished that there is no way to do it with the grant all on database [schema]...-option.

[GENERAL] using warm standby with drbd???

Hi All! I have configured the warm standby using WAL FILES and DRBD. The wal files are generated as server A. I am using DRBD to replicate these wal files between server A and server B. The DRBD service is running as Primary on Server A and secondary on Server B. The wal_files are written to the

[GENERAL] GRANT ALL ON recursive for all tables in my scheme?

I recently searched for a way to grant permissions to a new created user for all tables in a scheme or database. I just found ways who uses psql and scripts. But I'm astonished that there is no way to do it with the grant all on database [schema]...-option. Actually i thought that a grant on a

Re: [GENERAL] Planner: rows=1 after similar to where condition.

Joris Dobbelsteen [EMAIL PROTECTED] writes: From: Tom Lane [mailto:[EMAIL PROTECTED] If you increase the stats target for the column to 100 or more then it will try actually applying the regexp to all the histogram entries. That might or might not give you a better estimate. A new test

Re: [GENERAL] [SQL] Documenting a DB schema

-- Original message -- From: Shahaf Abileah [EMAIL PROTECTED] I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com http://www.redfin.com/ ), so that the developers using this database have a better idea what

Re: [GENERAL] GRANT ALL ON recursive for all tables in my scheme?

On Tuesday 04 March 2008, A Lau [EMAIL PROTECTED] wrote: I recently searched for a way to grant permissions to a new created user for all tables in a scheme or database. I just found ways who uses psql and scripts. But I'm astonished that there is no way to do it with the grant all on database

Re: [GENERAL] using warm standby with drbd???

On Tuesday 04 March 2008, libra dba [EMAIL PROTECTED] wrote: How else can i replicate the wal_files? ( i don't want to user common file system ,,, NFS,,, etc.)? scp Another thing which i want to ask is that if we are generating archives every 1 minute. then what happens to the data which

[GENERAL] I don't understand this WARNING on pg_ctl startup

=== [EMAIL PROTECTED]:/usr/lib/postgresql/8.2/bin$ 2008-03-04 15:47:21 PST LOG: 0: could not load root certificate file root.crt: no SSL error reported 2008-03-04 15:47:21 PST DETAIL: Will not verify client certificates. 2008-03-04 15:47:21 PST LOCATION:

Re: [GENERAL] using warm standby with drbd???

On Mar 4, 2008, at 6:02 PM, Alan Hodgson wrote: On Tuesday 04 March 2008, libra dba [EMAIL PROTECTED] wrote: How else can i replicate the wal_files? ( i don't want to user common file system ,,, NFS,,, etc.)? scp Actually, scp is a bad choice for transfering wal files if you're planning

[GENERAL] PGPOOL_HA

Hi, I'm going to implement PGPOOL-II in my system. I was reading in the official site (http://pgfoundry.org/projects/pgpool/) and I found and excelent solution called PGPOOL-HA, however I've not found information of how implement this. Does anyone has implement it? In the positive case, can

[GENERAL] Import file into bytea field in SQL/plpgsql?

Hi! What I want to do: Import a file from the file system into a bytea field of a table. I know how to do it with large objects: INSERT INTO mytable(oid_fld) VALUES (lo_import('/mypath/myfile')); And export from there: SELECT lo_export(oid_fld, '/mypath/myfile2') FROM mytable WHERE some

Re: [GENERAL] I don't understand this WARNING on pg_ctl startup

Ralph Smith wrote: === [EMAIL PROTECTED]:/usr/lib/postgresql/8.2/bin$ 2008-03-04 15:47:21 PST LOG: 0: could not load root certificate file root.crt: no SSL error reported 2008-03-04 15:47:21 PST DETAIL: Will not verify client certificates. 2008-03-04

Re: [GENERAL] how do you write aggregate function

On Tue, Mar 4, 2008 at 8:44 AM, Justin [EMAIL PROTECTED] wrote: I searched the archive of the mail list and did not find anything I don't know if you've already seen this, but this is the question that I asked a while back: http://archives.postgresql.org/pgsql-general/2007-12/msg00681.php

[GENERAL] Find Number Of Sundays Between Two Dates

Hai EverBody, Can I know what is the query by which we can find the number of sundays between two given dates in postgres Thanks In Advance, Raghu... -- View this message in context: http://www.nabble.com/Find-Number-Of-Sundays-Between-Two-Dates-tp15843956p15843956.html Sent from

Re: [GENERAL] Find Number Of Sundays Between Two Dates

am Tue, dem 04.03.2008, um 22:16:07 -0800 mailte raghukumar folgendes: Hai EverBody, Can I know what is the query by which we can find the number of sundays between two given dates in postgres No problem, for instance for month january 2008: test=*# select count(1) from