[PERFORM] Cost of INSERT rules

view query before doing the update ? cu -- ----- Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Taskforce:

[PERFORM] Implementing an regex filter

the second query would be much faster (about 2mins vs. 18mins). But I really wonder, why is processing one huge regex so dramatically slow ? BTW: in some tables I'm using the username instead (or parallel to) the numerical id to skip joins against the user table. But I'm not sure if

[PERFORM] Performance on writable views

ive me some details about that issue ? cu -- --------- Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Tas

[PERFORM] Index + mismatching datatypes [WAS: index on custom function; explain]

igint vs. integer vs. oid. Of course I tried to use casted index (aka ON (foo::oid)), but it didn't work. What am I doing wrong ? cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931

Re: [PERFORM] Massive delete performance

unnecessary stuff as possible on copying ? >How can I increase this DELETE procedure because it is really slow??? > There are of corse a lot of data's to be deleted. Have you set up the right indices ? cu -- ---------

Re: [PERFORM] Why the planner is not using the INDEX .

y could create the query dynamically and then execute it. BTW: why isn't IN not usable with arrays ? cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/

Re: [PERFORM] Need help to decide Mysql vs Postgres

wn types. > That's really cool, plus the developer is a friendly guy. Is there anything similar for java ? cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metu

Re: [PERFORM] Select performance vs. mssql

to store mvcc information. cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

Re: [PERFORM] plain inserts and deletes very slow

amic query stuff) and the delphi application is the only one writing directly to this table. cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax:

Re: [PERFORM] plain inserts and deletes very slow

* Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Mon, Jul 04, 2005 at 02:17:47AM +0200, Enrico Weigelt wrote: > > * David Mitchell <[EMAIL PROTECTED]> wrote: > > > Perhaps if you are doing a lot of inserts and deletes, vacuuming every 6 > > > minutes woul

Re: [PERFORM] plain inserts and deletes very slow

dnt code it). > And what is your method for running the query 'manually'. Are you > running it locally or from a remote machine or what? using psql remotely - database and client machines are sitting on the same wire. cu -- ---------

Re: [PERFORM] plain inserts and deletes very slow

et the tables back into shape after them slowing down as they > have). hmm. I've just done vacuum full at the moment on these tables, but it doesnt seem to change anything :( cu -- --------- Enrico Weigelt== metux I

Re: [PERFORM] plain inserts and deletes very slow

esnt seem to have any effect on that. cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] --

Re: [PERFORM] plain inserts and deletes very slow

* Enrico Weigelt <[EMAIL PROTECTED]> wrote: forgot to mention: + linux-2.6.9 + postgres-7.4.6 + intel celeron 2ghz + intel ultra ata controller + 768mb ram cu -- - Enrico Weigelt== metux IT s

Re: [PERFORM] plain inserts and deletes very slow

* Steinar H. Gunderson <[EMAIL PROTECTED]> wrote: > On Mon, Jul 04, 2005 at 12:45:37AM +0200, Enrico Weigelt wrote: > > my application reads and writes some table quite often > > (multiple times per second). these tables are quite small > > (not more than 20 tuples), bu

[PERFORM] plain inserts and deletes very slow

ve me advice ? cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] -

Re: [PERFORM] investigating slow queries through pg_stat_activity

plication, you could try to encapsulate the queries into views - this makes logging and tracking down problems much easier. cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www:

Re: [PERFORM] BLOB's bypassing the OS Filesystem for better Image loading speed?

ementation. Of course there may be a lot of good reasons to put images into the database, ie. if some clients directly work on db connections and all work (including image upload) should be done over the db link. cu -- --------- Enric

[PERFORM] index on different types

anual casting required ? thx -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROT

[PERFORM] foreign key performance

Hi folks, do foreign keys have any influence on performance (besides slowing down huge inserts) ? do they bring any performance improvement ? thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931

Re: [PERFORM] immutable functions vs. join for lookups ?

t kind of query should I use ? Is a join better than a function ? cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 em

Re: [PERFORM] immutable functions vs. join for lookups ?

ever* changes in practise (or at most there will be an insert once a year) isnt there any way to enforce the function to be really immutable ? cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931

[PERFORM] index not used

lect * from foo where id = 2; I've got only 15 records in this table, but I wanna have it as fast as possible since its used (as a map between IDs and names) for larger queries. thx -- --------- Enrico Weigelt== metux

Re: [PERFORM] immutable functions vs. join for lookups ?

* Tom Lane <[EMAIL PROTECTED]> wrote: > Enrico Weigelt <[EMAIL PROTECTED]> writes: > > c) CREATE FUNCTION id2username(oid) RETURNS text > > LANGUAGE 'SQL' IMMUTABLE AS ' > > SELECT username AS RESULT FROM users WHERE uid = $1';

[PERFORM] immutable functions vs. join for lookups ?

we have several 10k of items ? thx -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PRO

Re: [PERFORM] clear function cache (WAS: SQL function inlining)

* Stephan Szabo <[EMAIL PROTECTED]> wrote: > > On Thu, 24 Mar 2005, Enrico Weigelt wrote: > > > * Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > > On Thu, Mar 24, 2005 at 02:32:48PM +0100, Enrico Weigelt wrote: > > > > > > > BTW: i

Re: [PERFORM] clear function cache (WAS: SQL function inlining)

* Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Thu, Mar 24, 2005 at 02:32:48PM +0100, Enrico Weigelt wrote: > > > BTW: is it possible to explicitly clear the cache for immutable > > functions ? > > What cache? There is no caching of function results.

Re: [PERFORM] View columns calculated

ably a couple other things.) What about functions ? I'm using several (immutable) functions for mapping IDs to names, etc. cu -- - Enrico Weigelt== metux IT service phone: +49 36207 519931

[PERFORM] clear function cache (WAS: SQL function inlining)

ge is quite unpredictable. thx -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellpho