Re: [ADMIN] Is it harmless?

Yep , We do connect to 5432 to see if pg is up every min and disconnect. it is not a db connection but a simple opening / closing of TCP/IP socket for port 5432. that is the cheapest port monitoring i could think of regds mallah. On Tuesday 17 December 2002 09:54 pm, Tom Lane wrote: > "Rajes

[ADMIN] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] Slow Executing queries

Tom:We have a IBM NetServer i with 2.5 GB de Ram and RAID 5 with 137 GB, twoPIV Xeon at 1.6 GHZ... I mounted Linux in this server withPostgreSQL 7.3, we start to deploy the database and we have a lot ofperformance problems, i need help for tune up the serveri read the faqs,a lots of documents a

[ADMIN] how to dump and restore unicode databases?

i have two machines, one with postgres 7.2.X and one with 7.3. Both their encodings are set to UNICODE. on the first i have crated a unicode database, with german, swedish and english texts, more to come. on that machine i dump the db with pg_dump -c -s ncg and pg_dump -D -a ncg. on that machine i

[ADMIN] How to determine which long running session???

In Oracle you can look at the v$session view to get session information and how long they have been running. What is the equivalent in PostgreSQL? TIA. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.co

Re: [ADMIN] Set-up Server on ISP

On 17 Dec 2002 at 10:34, Stephen R. Hartfield wrote: > I am considering using PostgreSQL for my web based programming. My > concern is how do I install the server on an ISP's host computer. > Many ISPs do not offer support or functionality for databases other > than SQL Server. Can someone give

[ADMIN] Set-up Server on ISP

Hi,   I am considering using PostgreSQL for my web based programming.  My concern is how do I install the server on an ISP’s host computer.  Many ISPs do not offer support or functionality for databases other than SQL Server.  Can someone give me some insight into this?   Thanks,   St

Re: [ADMIN] Is it harmless?

"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes: > the following "LOG" lines were found in my /var/log/pgsql > LOG: pq_recvbuf: unexpected EOF on client connection > LOG: incomplete startup packet > are they harmless? Harmless to PG, yes. They might indicate something worthy of investigatio

Re: [ADMIN] order by has no effect in index-choose?

Klaus Daum wrote: > i have: > > create table t (id int, s1 text, s2 text); > create index s1 on t using (id, s1); > create index s2 on t using (id, s2); > > [fill table t, analyse table t] > > select * from t where id=1 order by s1; > > -> is using index s2 select * from t where id=1

[ADMIN] Is it harmless?

Hi , the following "LOG" lines were found in my /var/log/pgsql LOG: pq_recvbuf: unexpected EOF on client connection LOG: incomplete startup packet LOG: pq_recvbuf: unexpected EOF on client connection LOG: incomplete startup packet LOG: pq_recvbuf: unexpected EOF on client connection LOG:

Re: [ADMIN] Is is possible to persuade the query planner that ~* operations are grossly expensive?

Nick Howden <[EMAIL PROTECTED]> writes: > Is is possible to persuade the query planner that ~* operations are grossly > expensive - or at least much more expensive than some other operations. I think you're trying to micro-optimize in the wrong place. > My reason is that I have a databsase on wh

[ADMIN] Is is possible to persuade the query planner that ~* operations are grossly expensive?

Is is possible to persuade the query planner that ~* operations are grossly expensive - or at least much more expensive than some other operations. My reason is that I have a databsase on which we do a lot of queries of the form SELECT * FROM primary_table secondary_table as t1 secondary