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 giv
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,
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 w
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 De
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
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
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?
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
>
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 o
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 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 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
haviour 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
ted Loop (cost=0.00..3443.90 rows=2 width=0) (actual
time=4.531..4.724 rows=3
loops=98)
-> Index Scan using main_order_idx on main_order (cost=0.00..5.87
rows=2 width=4)
(actual time=0.143..0.153 rows=1 loops=98)
Index Cond: (client_id = $3)
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)
WHERE
15 matches
Mail list logo