Re: [GENERAL] pgsql 7.4.1 copy - end-of-copy marker corrupt

On Thu, 2004-02-05 at 22:52, Martijn van Oosterhout wrote: > On Fri, Feb 06, 2004 at 01:11:24AM -0500, Tom Lane wrote: > > Jenny Zhang <[EMAIL PROTECTED]> writes: > > > ERROR: end-of-copy marker corrupt > > > CONTEXT: COPY author, line 49: "49\aoD{\BA

Re: [GENERAL] update slows down in pl/pgsql function

Oops, I named the var name the same as the column name. Changing it to something else solved the problem. Thanks, Jenny On Tue, 2003-12-16 at 15:54, Stephan Szabo wrote: > On Tue, 16 Dec 2003, Jenny Zhang wrote: > > > I have stored procedure written in pl/pgsql which takes abou

[GENERAL] update slows down in pl/pgsql function

on shopping_cart (cost=0.00..5.01 rows=1 width=144) (actual time=0.22..0.37 rows=1 loops=1) Index Cond: (sc_id = 260706::numeric) Total runtime: 1.87 msec (3 rows) Is it true that using pl/pgsql increases the overhead that much? TIA, Jenny -- Jenny Zhang Open Source Development Lab 12725

Re: [GENERAL] passing array as argument and returning an array in

array > > Variables : > - > > a alias for $1 > b _varchar > > Usage : > - > > b[1] = a[1]; > b[2] = a[2]; > > return b; > > Is it possible. > > TIA, -- Jenny Zhang Open Source Development Lab 12725 SW Millikan Way, Suite 400 Beaverto

[GENERAL] deadlock detected when inserting data

need more info. TIA, Jenny -- Jenny Zhang Open Source Development Lab 12725 SW Millikan Way, Suite 400 Beaverton, OR 97005 (503)626-2455 ext 31 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] how to get accurate values in pg_statistic

Hi, Last week I reported getting different execution plans for the same query against the same database. I did further investigation. After building the database, I did: vacuumdb -z DBT3 psql DBT3 -c "analyze supplier" psql DBT3 -c "analyze part" psql DBT3 -c "analyze partsupp" psql DBT3 -c "ana

[GENERAL] factors determining the execution plan

/power_query9.txt My test leads me to the following questions: What are the factors which determine the execution plan and cost? Does PostgreSQL check the system resource dynamically? If Inserts and Updates happened but vacuuming is not executed, dose the execution plan change? Thanks, -- Jenny Zhang

Re: [GENERAL] [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is

be interesting to > see..:-) > > > Let me know if you have any suggestions about how to improve the test kit (parameters, reported information, etc.), or how to make it more useful to PG community. Thanks, -- Jenny Zhang Open Source Development Lab Inc 12725 SW Millikan Way Suite