Re: [ADMIN] Too many IDLE in current_query

2011-07-12 Thread Vibhor Kumar
On Jul 12, 2011, at 9:08 PM, francescobocca...@libero.it wrote: > i know that this is just a snapshot of the situation of the server in a > particular moment, so i know that i can see all IDLE queries. > The strange thing is that there are quesries that are running from 34 days.I > think is str

Re: R: [ADMIN] Too many IDLE in current_query

2011-07-12 Thread Kevin Grittner
"francescobocca...@libero.it" wrote: > i add another question to my previous mail.. why all the rows of > my query have waiting field false? That indicates whether the query is waiting for a heavyweight lock to clear, not whether it is waiting for user input. -Kevin -- Sent via pgsql-admi

Re: [ADMIN] Too many IDLE in current_query

2011-07-12 Thread Kevin Grittner
"francescobocca...@libero.it" wrote: > i'm checking my postgresql server to try to monitoring all > activity that are running. > i run this query: > > postgres=# select > current_timestamp - query_start as runtime, > current_query > from pg_stat_activity > order by 1 desc; > The strange thin

R: [ADMIN] Too many IDLE in current_query

2011-07-12 Thread francescobocca...@libero.it
Hi, i add another question to my previous mail.. why all the rows of my query have waiting field false? Thanks Francesco >Messaggio originale >Da: francescobocca...@libero.it >Data: 12/07/2011 17.38 >A: >Ogg: [ADMIN] Too many IDLE in current_query > >Dear all, >i'm checking my postgre

[ADMIN] Too many IDLE in current_query

2011-07-12 Thread francescobocca...@libero.it
Dear all, i'm checking my postgresql server to try to monitoring all activity that are running. i run this query: postgres=# select current_timestamp - query_start as runtime, current_query from pg_stat_activity order by 1 desc; and the resul is many rows like this: runtime |

Re: [ADMIN] Maximum insert per second

2011-07-12 Thread Kevin Grittner
Jenish Vyas wrote: > I am able to insert 1190- 1210 records per seconds. > > Now I just want to know by what extend I could stretch it. > > What is the maximum insert I can achieve in one second? What is > the maximum number of insert postgresql achieved so far? I don't have hard numbers ha

[ADMIN] Maximum insert per second

2011-07-12 Thread Jenish Vyas
Hi All, Thank you all for your previous advices. Now I am able to insert 1190- 1210 records per seconds. Now I just want to know by what extend I could stretch it. What is the maximum insert I can achieve in one second? What is the maximum number of insert postgresql achieved so far? Postgres

Re: [ADMIN] Importing the dump file in postgresql-7.4.23

2011-07-12 Thread Tom Lane
saravanan writes: > I'm using PostgreSQL-7.4.23 version. I have one dump file that was taken > using pg_dumpall utility. Now i tried to import the dump file. But its > throwing me lot of *Invalid Command \N error* , *ERROR: type tsvector does > not exist* and *\t: extra argument "string" ignored

Re: [ADMIN] Importing the dump file in postgresql-7.4.23

2011-07-12 Thread Achilleas Mantzios
is your target DB >=8.x? Did you use to have tsearch2 installed in 7.4? Anyway, this is how we used to dump from 7.4 and load into 8.3: take the dump from 7.4, install 8.3 initdb, etc... cd /usr/local/src/postgresql-8.3.3 cd contrib/tsearch2/ make uninstall cd ../intarray/ make uninstall create

[ADMIN] Importing the dump file in postgresql-7.4.23

2011-07-12 Thread saravanan
Hi all, I'm using PostgreSQL-7.4.23 version. I have one dump file that was taken using pg_dumpall utility. Now i tried to import the dump file. But its throwing me lot of *Invalid Command \N error* , *ERROR: type tsvector does not exist* and *\t: extra argument "string" ignored error* I'm using