Re: [GENERAL] VACUUM degrades performance significantly. Database

"Stephen" <[EMAIL PROTECTED]> writes: > ""Dann Corbit"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > If you are always looking for exact matches, I would suggest > > experimenting with a hashed index. > > I already hashed the 5-way index under the column "id". Removing the 5

[GENERAL] How to quote text before inserting into database?

I am working with Python (psycopg). I have HTML with embedded Python that I'm inserting into a database and it could contain any character. Single quotes, at least, must be escaped (to two single quotes, right?) before inserting it into Postgres. This poses a problem when I get the data out

[GENERAL] Writers Wanted

Hello All: As the new Editor-N-Cheif of PostgreSQL.Org it is my job to make sure that people who want to write about PostgreSQL, can. I will be in constant communication with various publications and will be helping in the advocacy of PostgreSQL through wide spread dissemination

Re: [GENERAL] ShmemAlloc errors

On Fri, 17 Oct 2003 15:47:10 +0100, Nick Burrett <[EMAIL PROTECTED]> wrote: >CREATE TABLE fiveminute ( server CHAR(32), > stamp TIMESTAMP, > bytesin BIGINT CHECK (bytesin >= 0), > bytesout BIGINT CHECK (bytesout >= 0)); >

Re: [GENERAL] ShmemAlloc errors

Nick Burrett <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Have you thought about >> collapsing these into *one* table with an extra key column? Also, it'd >> likely be better to combine the date and time into a timestamp column. > I tried it back in the days when we only had around 1000 table

Re: [GENERAL] Cygwin? or paid version from SRA?

Richard Huxton wrote: On Wednesday 15 October 2003 05:34, David So wrote: For deploying PostgreSQL on Windoz platform, which one is a better option (performance, reliability) ? Thru Cygwin or Paid version from SRA? I know one person who was quite happy with the windows version from http://www.dbex

Re: [GENERAL] ShmemAlloc errors

Nick Burrett <[EMAIL PROTECTED]> writes: > The original table definition was exactly this: > CREATE TABLE fiveminute ( server CHAR(32), >stamp TIMESTAMP, >bytesin BIGINT CHECK (bytesin >= 0), >bytesout BIGINT CHECK

Re: [GENERAL] maximum number of client connections?

3000 clients = B of 6000(minimum) -> 6000 * 8KB = 48000KB 1MB = 1024KB 48000KB/(1024KB/MB) = 46.875 MB is my math right? only 47MB?? reid > -Original Message- > From: Dann Corbit [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 16, 2003 3:14 PM > To: Mark Harrison > Cc: [EMAIL PROT

[GENERAL] Perl and Postgres

Hi! Where can I find examples to accesing postgres with perl. TIA _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/ ---(end of broadcast)--- TIP 3:

[GENERAL] ecpg and blob's

hi. i'm writing an api with the ecpg interface and need to know how to handle blob's with it. i serached a lot yet, but did not find anything usefull. does someone know about it? thanks a lot. harjo ---(end of broadcast)--- TIP 8: explain analyz

Re: [GENERAL] VACUUM degrades performance significantly. Database

Vivek Khera wrote: "S" == Stephen <[EMAIL PROTECTED]> writes: S> The system is actually idling when I ran the tests (load average: 0.01, S> 0.02, 0.00). When VACUUM runs, load average increases quickly (load average: S> 1.77, 0.60, 0.21) just by running psql on command line and issuing 2 S> que

Re: [GENERAL] ShmemAlloc errors

Tom Lane wrote: Nick Burrett <[EMAIL PROTECTED]> writes: Tom Lane wrote: We don't normally hear of people needing that --- is there anything unusual about the schema of this database? Not particularly. The database consists of around 3000 tables created using this: CREATE TABLE vs_foo (date

[GENERAL] connecting to external database tables outside of the postgres database

Is it possible to establish a connection from within a postgres database to another external database on the network, i.e., not a java or scripting connection, BUT by some type of table definition within the postgres database of that external database table source - something similar to a proxy def

Re: [GENERAL] XOR logical operator

On Fri, 17 Oct 2003 01:04:48 -0700 (PDT), Nagib Abi Fadel <[EMAIL PROTECTED]> wrote: >Is there a XOR logical operator in Postgresql Yes: != Servus Manfred ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://

Re: [GENERAL] XOR logical operator

On Fri, 17 Oct 2003, Nagib Abi Fadel wrote: > Is there a XOR logical operator in Postgresql, or a > function for XOR ?? > > I only found in the docs a Binary XOR (#). > > I need to do the following checkup: > (field1 is NULL XOR field2 is NULL XOR filed3 is NULL) Good idea. hmmm CREAT

Re: [GENERAL] XOR logical operator

Hello, PostgreSQL hasn't logical operator XOR. But You can find it in cookbook http://www.brasileiro.net/postgres/cookbook/view-recipes.adp?section_id=41&format=long Regards Pavel On Fri, 17 Oct 2003, Nagib Abi Fadel wrote: > Is there a XOR logical operator in Postgresql, or a > function for

[GENERAL] XOR logical operator

Is there a XOR logical operator in Postgresql, or a function for XOR ?? I only found in the docs a Binary XOR (#). I need to do the following checkup: (field1 is NULL XOR field2 is NULL XOR filed3 is NULL) i can't right it like this: ( (field1 is NUll or field2 is NUll) and (field1 is NUll or fi

Re: [GENERAL] ShmemAlloc errors

Tom Lane wrote: Nick Burrett <[EMAIL PROTECTED]> writes: $ pg_dumpall >full.db pg_dump: WARNING: ShmemAlloc: out of memory pg_dump: Attempt to lock table "vs_dfa554862ac" failed. ERROR: LockAcquire: lock table 1 is out of memory pg_dumpall: pg_dump failed on bandwidth, exiting Looks like you