Greetings,
I am sure I have seen this, but I have searched the docs, and
tried to search the archives, which was a definite exercise in futility.
How can I list the triggers on a specific table? I tried the following:
= select * from pg_trigger where tgargs like '%foo%' ;
ERROR:
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 when moving old database
I never used it, but maybe you could test it:
http://www.thekompany.com/projects/kugar/
Raph
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
We have 7.1.3 PostgreSQL running on a NetVista PIII 800 with 512 MB ram 'n 2
80 GB IDE 10krmp Seagate disks, using a linked script for boot in
/etc/rc.d/rc2.d with hdparm -X66 -u1 -d1 -m16 -c3
We cannot use copy because of strange char...
So...we make at week (WITH 8K ROWS), from a güinbox
Brian McCane [EMAIL PROTECTED] writes:
How can I list the triggers on a specific table?
select * from pg_trigger where tgrelid =
(select oid from pg_class where relname = 'foo');
This table is documented now in the 7.2 documentation; see
Brian McCane wrote:
How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
SELECT t.oid, t.*
FROM pg_trigger t,
At 11:01 AM 1/29/02 +0800, Lau NH wrote:
Hi all,
I am writing a php script to backup my postgres database
through web interface, but my database is password required. When I
do a pg_dump at the linux shell prompt, it will prompt for password in
order to backup the database, does anyone know how
Hi,
anybody has an experience how is stable postgresql under Windows system ?
I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed
by very bad performance. Are there something I could tune ?
I got 250 sel/sec on simple select from table with 500 rows !
Under Linux I have 2500
Oleg Bartunov [EMAIL PROTECTED] writes:
anybody has an experience how is stable postgresql under Windows system ?
I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed
by very bad performance. Are there something I could tune ?
I got 250 sel/sec on simple select from table with
On Wed, 30 Jan 2002, Arguile wrote:
Brian McCane wrote:
How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
How were you inserting the data? Were you doing multiple inserts per
transactions? Copy? That sounds really slow to me.
The database mainly contains integers, which represent the behavior of
internet users on our site, so it's very compact data.
We used multiple insert with mysql but
On Wed, 30 Jan 2002, Brian McCane wrote:
On Wed, 30 Jan 2002, Arguile wrote:
Brian McCane wrote:
How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to
Brian McCane [EMAIL PROTECTED] writes:
Thanks Tom and Arguile that definitely helps. Now for my more
pressing, but forgotten question. Shouldn't PostgreSQL have automatically
dropped that trigger when I dropped the table?
It should, and it does.
IIRC, there's a bug in some versions
Oleg Bartunov [EMAIL PROTECTED] writes:
anybody has an experience how is stable postgresql
under Windows
system ?
I tried postgresq 7.1 under Cygwin, Windows 98 and
was dissapointed
by very bad performance.
As you might guess, Cygwin's speed depends heavily on
the version of Windows you
14 matches
Mail list logo