name[] = { JOHN , ALEX , TEST ,""}
SQL : select name from table1 where 'TEST' = any (name)
return: { JOHN , ALEX , TEST }
in this sql command, how can i get the index of 'TEST' is 3 ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
i use the "ps -ef | grep postgres" to see all the connections. the
connection's status is "Idle in transcation".
and i use the " du -h /mydb" to check the disk size. The disk size of
mydb has increased from 400MB to 600MB.
Why? because of the "idle in transcation" ?
my pg version:8.1.3
OS: Lin
i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3)
1. enable autovacuum without using vacuumdb -f mydb in crontab.
2. using crontab to vacuumdb in every 10 min (autovacuum disable)
the method 2 got more free space than method 1.
the disk size of database still increased in m
On 12月6日, 下午10�r14分, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Charles.Hou wrote:
> > this is the pg_log...
> > after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
> > not mydatabase...
>
> Is there an ERROR in the log? My guess is
this is the pg_log...
after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
not mydatabase...
why?
i didn't change any configuration...
2007-12-04 10:14:55 CST 23858 LOG: autovacuum: processing database
"mydatabase"
2007-12-04 10:23:15 CST 31601 LOG: autovacuum: processing datab
how can i get the int value using the sql language? like this,
"select cost from my_money_table " , the data type of cost is float.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/f
is there any way to know the database loading? because i want to know
the performance after i use the pgpool.
how can i know the perofrmance have been increased?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 9 20 , 3 11 , Hannes Dorbath <[EMAIL PROTECTED]> wrote:
> On 20.09.2007 04:34, Charles.Hou wrote:
>
> > i have installed thepgpoolin the server and start it. but how can i
> > know it's working? i means that the clients connected to the database
> &g
On 9 21 , 10 04 , "Charles.Hou" <[EMAIL PROTECTED]> wrote:
> On 9 20 , 3 11 , Hannes Dorbath <[EMAIL PROTECTED]> wrote:
>
> > On 20.09.2007 04:34, Charles.Hou wrote:
>
> > > i have installed thepgpoolin the server and start it. but how can i
>
i have the log analysis report by using the pgFouine. in the part of
Slowest queries, the update commands " update com_status set
travel=620.70001220703 where no=1" have the high Av.duration(s). how
should i do to solve this problem? why this simple command can take
up
the most time?
Av.duration(
11 matches
Mail list logo
