Ralph van Etten wrote:
Hoi,
I searched the archives but couldn't find an answer to this:
I have a table (simplyfied)
CREATE TABLE test (
id INT PRIMARY KEY,
name VARCHAR(250)
);
I insert records with
INSERT INTO test (id, name)
SELECT COALESCE(MAX(id)+1, 1), 'name' FROM test
Ofcourse this
Marc G. Fournier wrote:
The WWW folks just put up a survey asking:
If there was an official newsgroup for postgresql, would you switch to
using Usenet from using the mailing lists?
Switch no, use in addition yes.
I subscribe to several of the mailing lists that I find most
interesting, but I
On 1 Nov 2004 at 20:45, Glen Eustace wrote:
When I tried to reload the production database dump, I got a series of
errors relating to functions. I repeated the exercise but this time did
a \df prior to trying to load the database. In the public schema for the
newly created admin database
On 23 Oct 2004 at 10:42, A. Mous wrote:
Note, if I install the ODBC driver separately, these characters do not show
up. Therefore, this seems to be an issue specific to the Win installer, no?
No, not as such. It is a problem with the version of the ODBC driver that
ships with Beta2 Dev3.
On 19 Oct 2004 at 17:35, Josh Close wrote:
Well, I didn't find a whole lot in the list-archives, so I emailed
that list whith a few more questions. My postgres server is just
crawling right now :(
Unlike many other database engines the shared buffers of Postgres is
not a private cache of
On 20 Oct 2004 at 11:37, Josh Close wrote:
On Wed, 20 Oct 2004 09:52:25 -0600, Scott Marlowe [EMAIL PROTECTED] wrote:
1: Is the bulk insert being done inside of a single transaction, or as
individual inserts?
The bulk insert is being done by COPY FROM STDIN. It copies in 100,000
rows at
On 20 Oct 2004 at 13:34, Josh Close wrote:
How long does 100,000 rows take to insert exactly?
I believe with the bulk inserts, 100k only takes a couple mins.
Hmm, that seems a bit slow. How big are the rows you are inserting? Have you checked
the cpu and IO usage during the inserts? You
On 20 Oct 2004 at 14:09, Josh Close wrote:
On Wed, 20 Oct 2004 19:59:38 +0100, Gary Doades [EMAIL PROTECTED] wrote:
Hmm, that seems a bit slow. How big are the rows you are inserting? Have you
checked
the cpu and IO usage during the inserts? You will need to do some kind of cpu/IO
On 20 Oct 2004 at 15:36, Josh Close wrote:
On Wed, 20 Oct 2004 20:49:54 +0100, Gary Doades [EMAIL PROTECTED] wrote:
Is this the select(1) query? Please post an explain analyze for this and any other
slow
queries.
I think it took so long 'cause it wasn't cached. The second time I ran
On 19 Oct 2004 at 13:00, Josh Close wrote:
Is there a way to remove idle connections? My postgres server is
getting serveral hundred idle connections. It's due to a postgres .NET
provider not closing the connections properly. I don't want to kill
them all, or restart postgres everytime the
On 19 Oct 2004 at 13:32, Josh Close wrote:
The provider is corelabs. The programmer that wrote the code says he's
closing the connections, but they aren't actually closing.
Any ideas? Or better yet, do you know of a good postgres .net provider?
Hmm, I've had lots of problems with the
On 3 Oct 2004 at 11:24, Scott Marlowe wrote:
On Sun, 2004-10-03 at 06:33, stig erikson wrote:
There are a few tools I've seen that will try to convert ASP to PHP, but
for the most part, they can't handle very complex code, so you're
probably better off just rewriting it and learning PHP on
in this area, is this so?
Cheers,
Gary.
On Sat, 21 Feb 2004 11:15:50 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
Gary Doades [EMAIL PROTECTED] writes:
Is there someway to force the use of an index. Or at least get the
backend to substitue the parameters in a function before doing the
first query
2004 11:15:50 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
Gary Doades [EMAIL PROTECTED] writes:
Is there someway to force the use of an index. Or at least get the
backend to substitue the parameters in a function before doing the
first query plan so it has more typical values to work with?
Could
I have a very similar problem. I put the following SQL into a
function:
SELECT VS.*,VL.TEL1,SC.CONTRACT_ID,SC.CONTRACT_REF, SC.MAX_HOURS,
SC.MIN_HOURS,
(SELECT COUNT(*) FROM TIMESHEET_DETAIL
JOIN MAIN_ORDER ON (MAIN_ORDER.ORDER_ID = TIMESHEET_DETAIL.ORDER_ID
AND MAIN_ORDER.CLIENT_ID = $3)
15 matches
Mail list logo