ter:
$ ledit | psql yourdatabase
...my 2 cents
--
Jean-Paul ARGUDO
DBA PostgreSQL, MySQL, Oracle, Ingres
Membre de l'April http://www.april.org
---(end of broadcast)---
TIP 2: you can get off all lists at once wi
CPU 8.92s/14.11u sec elapsed 1306.20 sec.
- The vacuum is still going along fine.
Backups are proceeding without incident ( using pg_dump )
DELETE's are proceeding without incident
Hope this is enough information.
Kind Regards.
--
Paul L
> AFAIK we never actually *had* IPV6 support in those datatypes, only
> stubs for it.
the inet_net_pton implementation that was brought in from BIND had its
IPv6 portions scrubbed. micro-over-optimization of the contributed
"bitncmp" caused the "ipv4 as int" assumption to reoccur. i'm going to
Forwarded Message
Date: Fri, 20 Apr 2001 08:37:22 -0700 (PDT)
Message-Id: <[EMAIL PROTECTED]>
To: Paul A Vixie <[EMAIL PROTECTED]>
Subject: Re: Appliance caching server configuration database schema
In-Reply-To: <[EMAIL PROTECTED]>
From: [EMAIL PROTECTED] (Andreas Gustafsson)
Paul A.
bute | Type
---+-
op_id | integer
unique btree (primary key)
^^ ^
Watch for unique indices created with CREATE UNIQUE INDEX ...
Cheers,
--
Jean-Paul ARGUDO
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
pe functionality about prepared cursors, bind variables, etc will
come soon in PG :-)
We actually think about solutions to patch PostgreSQL and contribute
this way, adding a feature we need for business.
Thanks.
--
Jean-Paul ARGUDOIDEALX S.A.S
Consultant bases
(plz cc me on your replies, i'm not on pgsql-hackers for some reason.)
http://www.vix.com/~vixie/results-psql.png shows a gnuplot of the wall time
of 70K executions of "pgcat" (shown below) using a CIDR key and TEXT value.
(this is for storing the MAPS RSS, which we presently have in flat files.)
> 1) Have you ran vacuum analyze after all these inserts to update database
> statistics? :) Without vacuum, pgsql will opt to table scan even when
> there's an index.
i hadn't, but i did, and it didn't make that particular difference:
vixie=# explain select file from rss where addr = '1
the prior results (http://www.vix.com/~vixie/pgsql-results.png) showed:
~70ms usual INSERT time (~1.5sec -> ~1.25sec occasional)
~250ms usual SELECT time (~1.5sec occasional)
changing the attribute i key by to be PRIMARY KEY improved things a lot;
the new results (http://www.vix.
> > anybody know what i could be doing wrong? (i'm also wondering why SELECT
> > takes ~250ms whereas INSERT takes ~70ms... seems counterintuitive, unless
> > TOAST is doing a LOT better than i think.)
>
> I would think that this is entirely due to planning the query. An INSERT
> has no decision
for my pgcat utility i now know i have to use \nnn octal quoting for
nonprintables in the generated INSERT commands. but in testing, i
found the following oddity. this is in 7.1-b1 (cvs-current).
vixie=> create table foo ( bar text );
CREATE
vixie=> insert into foo value
> See bytea, though its presentation format leaves something to be desired IMHO
>
> > how would someone be expected to store, say, a GIF image in a TOAST text?
>
> One would not. A TOASTed bytea is the appropriate column type.
thanks -- that's EXACTLY what i needed.
ting the FOREIGN KEY vs.
when adding data after the key is entered, it seems reasonable to suspect a
bug in the first case.
Any chance this might be addressed for 7.1?
Thank you,
Paul-Andre Panon
--
[EMAIL PROTECTED]
<>
PGUniqID.sql
prijs from artcredinkoopprijzen where
int_crednr = 2 OR int_crednr = 3') as c(int_artnr integer, supp1
float4, supp2
float4);
Am I doing something wrong or is this a limitation of the
function?
With kind regards,
Paul
Please take a look at it and tell me if this could be usefull or not..
Thanks a lot,
--
Jean-Paul Argudo
www.postgresqlfr.org
www.dalibo.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choos
It seems that the suggestion to fill intermediate positions with
NULLs would be preferable to the current behavior.
I know of no requirement to populate arrays in sequence in any other
language so I think other programmers would be surprised too by the
current behavior.
Paul
Tom Lane
BA, and I need a good CRM solution for personal and profesional
purposes.
Please tell me if my experience can help you in any way, I'd be really
glad in participating your project.
I can offer public CVS, web, etc.. for the project if you want.
Overall, I think we're both French ;-))
Ch
note that in-lining is done in both the compiler and the linker.
Thanks,
Paul
----
-
Paul van den Bogaard
[EMAIL PROTECTED]
ISV-E -- ISV Engineering, Opensource Engin
ty
build script. Just to get that "ipo"-ing done and tested.
I'll keep you all updated on the results. If we decide it is too good
to be excluded can we start thinking about an adaption of the build
environement. Hope this sound fair and acceptable to all.
Thanks so far for all t
ure I am biased as a Sun employee :-),
but it is not likely to be something a dba would like to master. The
availability of "generic" scripts does add value.
BTW I wonder if we could somehow combine DTrace as a contextual tool
with the counters provided through the stats interface.
/entry/
leight_weight_lock_contention
I will add more posts on all the other LWlock findings and the
instrumentation method being used. Unfortunately a high priority
project popped up I need to focus on. So please be patient. Hope to
finish this in the first week of april.
Thanks,
Paul
On
/entry/
leight_weight_lock_contention
I will add more posts on all the other LWlock findings and the
instrumentation method being used. Unfortunately a high priority
project popped up I need to focus on. So please be patient. Hope to
finish this in the first week of april.
Thanks,
Paul
On
Peter,
finally I had a chance to check it out. One word: perfect!
Thanks
Paul
On 25-feb-2008, at 19:09, Peter Eisentraut wrote:
Am Mittwoch, 6. Februar 2008 schrieb Paul van den Bogaard:
I was hoping someone in the community already has a makefile that
"just" creates object fi
just started with 8.4 devel. Still focussing on LWlocks. With the
same load (#users & benchmarktool) I now see LockID 11
(CLogControlLock) to be in the top waiting list.
This one was never noticable in 8.3.
Did anything change with respect to this?
Thanks
to really measure the impact of the new
setting is necessary too. Especially when looking in the direction of
auto tuning. Proper measurement is crucial to enable correct analysis.
Of course I am in favor of doing this with DTrace, however not all
platforms can benefit in that case :-)
--
nitialisation? Or is there another routine (or two ...)
that I need to call in order to make things working.
Advise on how to proceed or pointers to docs in which this stuff is
explained are highly apprec
301 - 326 of 326 matches
Mail list logo
