affic over 300,000 new entries. The
customer doesn't do many queries but, when they do, they are complex and can
take a long time. Thus, I'm trying to manage the settings to handle the input
efficiently but also to provide resources for queries to execute in a timely
manner.
Thank You,
Has anybody used pgtune? How reliable are the results? Are they a good
baseline to work from?
Thanks.
n the conf file so this can be directed to another filesystem
(such as the /db)?
Thanks,
Steve Erickson
Senior Developer
NOTICE: This email, including any attachments, is covered by the Electronic
Communications Privacy Act, is confidential and may be legally privileged. If
you are not th
We've got a server running Ubuntu 9.04 and Postgres 8.3. They're old, but
cannot be upgraded at this time. I need to install plpython but can't find a
site to apt-get. Is there one out there?
Steve Erickson
Senior Developer
612.242.1343 cell
NOTICE: This email, including
ct any miracles, but want to be sure there isn't less intensive
alternative out there.
Thanks,
Steve Erickson
t;function foo() does not exist" if it indeed does not
exist. Shouldn't the "create or replace" just create it in this instance?
Why the error?
Thanks,
Steve Erickson
Senior Developer
266 East 7th Street, Floor 4
Saint Paul, MN 55101
651.925.3237 office
612.242.134
27;ve tried
selecting the tab and dragging it to the tab row below, left, right, etc.
but cannot get the tab back in the section I want it.
I'm running version 1.14.2 on OSx 10.6.8 and Postgres 8.4.
Thanks,
Steve Erickson
Senior Developer
266 East 7th Street, Floor 4
Saint Paul
I'm using pgAdmin 1.12.3 on Mac OSx. I have functions that use a Type rowtype
to hold the results of a query. When I change the query to add/remove columns,
I also change the Type, then do a drop, then create, and get a success message.
However, I then need to drop and create all dependent ob
