change.
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
the search order goes, the link you gave does not validate the
behavior I see on my fully patched version of XP and fully patch versions
of win2k in a corp environment.
The MSDN docs are not always correct or fully updated.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
You could also use Lazarus.
http://www.lazarus.freepascal.org/
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP
this point. Would anyone else find this
useful?
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
---(end of broadcast)-
caches etc.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
Scott Marlowe wrote:
On Mon, 2006-06-26 at 08:59, Tony Caduto wrote:
MG wrote:
Hello,
we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.
When we do a big SELECT-query the whole maschine becomes very very
very slowly or stands.
The maschine has 3 GB RAM, so we
e using
DBI Link instead of DBlink?
I thought DBLink was just for Postgresql databases?
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---
.postgresql.org/docs/faqs.FAQ.html
--
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
---(end of broadcast)---
TIP 6: explain analyze is your friend
-(end of broadcast)---
TIP 6: explain analyze is your friend
You just have to set it at the table level.
You should check out PG Lightning Admin, it has a really nice Grant
Manager that is grid based that makes this sort of thing
very easy to setup.
--
Tony Ca
application with.
You can get it here:
http://www.amsoftwaredesign.com/downloads/pg_installer_setup.zip
It uses a delphi DLL to handle things like the do the cluster init.
All source is included.
This is of course for win32.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
http://news.zdnet.com/2100-3513_22-6100795.html
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 1: if posting
http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
Don't know the validity of this dvd order test they did, but the article
claims Postgresql only did 120 OPM.
Seems a little fishy to me.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admi
Hi Brian,
Dblink is for postgresql to postgresql, you have to use DBI-Link for
connections to other databases.
http://pgfoundry.org/projects/dbi-link/
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql
eate a new
user from inside a function with a passed in username.
Another example where you would need EXECUTE is if you are working with
temp tables in a function.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your be
ot;Could not create socket: $!\n" unless $sock;
print $sock "null\r\n";
print $sock "send_broadcast\r\n";
print $sock $_[0]."\r\n";
print $sock $_[1]."\r\n";
close($sock);
$BODY$
LANGUAGE 'plperlu' VOLATILE;
--
Tony Caduto
AM Soft
some other tcp/ip
daemon.
You set up a rule to use Notify:
create rule InsertDetect as on INSERT to notify_test do notify recinsert
Then on the client side (if the client has libpq listen capability) you
listen for the incoming notification messages and react to them
accordingly.
--
Tony Cadu
ending a string with a
CRLF, and then if the command you send returns anything you just go into
a blocking
read until you get the response back.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql
401 - 417 of 417 matches
Mail list logo