[ADMIN] Full textsearch & gist

Hi, I'm experimenting with tsearch2. It works very good, but i have a few questions: - Is there a tsearch maillingslist ? - How can i create a muticolumn index of an date and a text field, so i for example can textsearch in de last few days. CREATE INDEX test_ix ON test USING gist(date,tsvect

[ADMIN] Index problems

mutch faster. It does'nt matter how big the table is, i've tried this with 100 times more, the result is the same. I've tried this on version 7.3.2 and 7.3.4. Regards, Ferdinand Smit == test=# SELECT r, count(r) FROM test GROUP BY r; r | count +--- 0 | 1344 1

[ADMIN] pg_dump error

Hi, What does this mean ?!? Is this a corrupt database, a bug or has the pg_dump not enough memory ? And ... how can i solve this problem ? $ pg_dump login | gzip > login.dump.gz pg_dump: ERROR: MemoryContextAlloc: invalid request size 4294967293 pg_dump: lost synchronization with server, re

[ADMIN] Postgres network preformance

Hi, Does anyone have any tips to improve the network preformance op Postgres ? To test the preformance i've done a little test using the perlmodule DBI. The ping last 1 ms and the computers are identical. The test script: #!/usr/bin/perl use DBI; my $connectTo = "dbi:Pg:dbname=testdb;host=obe

[ADMIN] How to rotate postgres logfiles

Hi, Does anyone know how to flush the logfiles op postgres. I need it for logrotate. '/usr/lib/postgresql/bin/pg_ctl reload' does not work, it does not create a new logfile. Regards, Ferdinand ---(end of broadcast)--- TIP 6: Have you searched

Re: [ADMIN] Connection problem

On Sunday 21 April 2002 09:35, Gunnar wrote: > I'm having problems connecting to my postgresql 7.2.1 running on my Debian > Linux box. > > (as root) > $ psql template1 foobar > psql: FATAL 1: IDENT authentication failed for user "foobar" > > Could anybody tell me what the problem is? > The user "

[ADMIN] How to repair a corrupt database

Hi, Sometimes when i import a psql dump, i found out that the original dabases had fault values (NULL value where NULL is not allowd, dubble primary keys ...). This cost me a lot of time to correct everything. So, how kan i repair a postgres database before i make an export ? Regards, Ferdina

Re: [ADMIN] slow inserts

> my $dbh=DBI->connect(dbi:Pg ...); > > my $insh = $dbh->prepare("Insert into table values (?,?,?)"; > $insh->begin_work; > foreach ($excelrow){ > parse; > $insh->execute($data1,$data2,$data3); > } $insh->commit; > > I have written a few script of that kind my self, and I was really > surp

Re: [ADMIN] INSERT performace.

Hi, > > > > > We have a fresh database and have begun to observe performance > > > > > degradation for INSERTs as a table went from empty to > > > > > 100,000-ish rows. Initial INSERTs were sub second while after > > > > > 30k rows, they were 1-3 seconds. > > > > > > > > we just hit this problem

Re: [ADMIN] INSERT performace.

On Sunday 27 January 2002 20:31, Sean Chittenden wrote: > > > We have a fresh database and have begun to observe performance > > > degradation for INSERTs as a table went from empty to 100,000-ish > > > rows. Initial INSERTs were sub second while after 30k rows, they > > > were 1-3 seconds. > > >

Re: [ADMIN] Character problems

Hi, After a few tests my conclusion is: - This problem only accist if you use UNICODE and use a char record (SQL_ASCII works fine). - I think the problem is that de character counter count special characters differend from normal characters. It only occur when you insert a string which size is

[ADMIN] Character problems

Hi, I have a problem with inserting/updating "strange" characters. I can only use strange characters at the beginning of a string. The select statement has'nt this problem. Is this a bug or am i doing something wrong ? Regards, Ferdinand Example: db=> select '\353x'; ?column? --

Re: [ADMIN] Please help

DATE OR DELETE ON adres FOR EACH ROW EXECUTE PROCEDURE fn_archive (); Ferdinand Smit ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[ADMIN] Query statistics problem

Hi, To improve the database preformence, I tried to monitor all the query's and the system usage by using the settings debug_print_query and show_query_stats in the /etc/postgres/postgres.conf. The only problem is that I can't find a relationship between the query and the statistics, so I can'

[ADMIN] Query stats

so I can't tell which query was extreemly slow. Is there a solution to this problem ? My configuration: - Postgresql 7.1.3 - Linux 2.2.19 - Distribution: Debian Yours, Ferdinand Smit ---(end of broadcast)--- TIP 1: subscribe and unsubscribe