Re: [GENERAL] application online upgrade strategy

ackup concept. If something goes wrong during an update at any point, you have a few seconds to restore the state of the system as it was before (If you can afford to lose any transactions at all). -- Regards, Hannes Dorbath ---(end of broadcast)---

Re: [GENERAL] psql Tab Completion in Windows

On 29.05.2007 09:26, Robert James wrote: Any way to get psql Tab Completion in Windows? I think this is because readline is not available/broken on win32. Use the cygwin version of psql. -- Regards, Hannes Dorbath ---(end of broadcast

Re: [GENERAL] Full vacuum may reclaim space

t eat quite a bit space.. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] DRDB risk factors?

using protocol C and fsync enabled in PG you don't lose a single commit. That is true for any ACID conform application. Be sure to you have your hardware right. Running DRBD on fsync/fua lying hardware is committing suicide. I can't stress that enough. -- Regards,

Re: [GENERAL] where find recent binary PostgreSQL

gards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Running v8.1 amd v8.2 at the same time for a transition

nyway, I guess wrappers are a must have like 3D desktops these days. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] 8.2.3 PANIC with "corrupted item pointer"

eap. What is the point of disabling fsync these days? -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Experiences of PostgreSQL on-disk bitmap index patch

Christan Josefsson wrote: > Any guess when 8.4 could be production ready? A year or more? Why don't you just use Bizgres? Right, they don't release that often, and 0.9 misses various fixes that went into PostgreSQL. But if it has what you are after and works for you.. -- Best re

[GENERAL] "Quota"

What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [GENERAL] "Quota"

On 27.06.2007 16:58, Dawid Kuroczko wrote: On 6/27/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote: What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? I am contemplating using XFS filesystem'

Re: [GENERAL] "Quota"

On 27.06.2007 15:18, Albe Laurenz wrote: Hannes Dorbath wrote: What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? Table spaces are the only solution I can think of. If you create a table space on a

Re: [GENERAL] db replication

blem?... There is hardly experience with this out, as it does not exist :) You might abuse dblink or slony to hack that. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] Design Tool

named these days, is about the only one. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message ca

Re: [GENERAL] Reasonable way to backup cluster Windows

On 03.07.2007 17:18, Andrus wrote: Which is reasonable way to backup cluster in Windows in compressed format ? Is the windows pg_dump different from the *nix one? If not, what is the problem with -Fc? -- Regards, Hannes Dorbath ---(end of broadcast

Re: [GENERAL] Design Tool

On 04.07.2007 10:44, Gabriele wrote: Anyway it doesn't support SQLite. Casestudio is a script based framework, there is lot of user contributed stuff. I remember having seen SQLite support somewhere, if not it's not so hard to add support yourself. -- Regards, Hann

Re: [GENERAL] Reasonable way to backup cluster Windows

, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Reasonable way to backup cluster Windows

t and use the task scheduler to run it in a given interval. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] tsearch2 in multilingual database?

r what language.. and yes, you have to set that every time. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Postgres 8.2 binary for ubuntu 6.10?

3A0%3A0%3A0%3A0%3A0&qDnStr=109&qArStr=1&qRtStr=2 and install it? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] How to pg_dumpall without root password

have a suggestion on what I should do? Locate pg_hba.conf (should reside in $PGDATA), open it in an editor, replace md5 with trust. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

Re: [GENERAL] Postgres 8.2 binary for ubuntu 6.10?

expect my distribution to offer me the choice of what version of PostgreSQL to install. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [GENERAL] Big table with UNION ALL or partitioning with Tsearch2

ng does change your query performance in any way? blockdev --setra 16384 /dev/sdX -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] slony over LAN and VPN

, read the Slony documentation. What is not clear to you? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] PHP pg_connect

ur password?\n"; } else if (true) { echo "OMG, something else went wrong!\n"; } } -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PHP pg_connect

On 17.07.2007 09:45, Hannes Dorbath wrote: This is a PHP, not a PostgreSQL question. Well, pg_last_error() might not return something in that case. You can create a custom error handler if the message is important for you. -- Regards, Hannes Dorbath ---(end of

Re: [GENERAL] Data on NAS / NFS

Lacie storage devices (Bigger Disk Extreme) To sum it up.. I'd say what you get with that setup is a dead slow, unstable PostgreSQL experience with a good chance of data corruption on power failure. -- Regards, Hannes Dorbath ---(end of

Re: [GENERAL] Linux distro

cons of each. As you say it it's a server, I assume you'll have it in a production environment. It's never a good idea to have anything in production with an OS you are not familiar with. -- Regards, Hannes Dorbath ---(end of broadcast)-

Re: [GENERAL] Installing Postgresql 8.2 on Windows Vista

be problematic. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] virtual database

Farhan Mughal wrote: > Does PostgreSQL support a Virtual Database like Oracle? No, but we have 2 external approaches: http://veil.projects.postgresql.org/curdocs/index.html http://www.kaigai.gr.jp/index.php?sepgsql -- Best regards, Hannes Dorbath ---(end of broadc

Re: [GENERAL] Persistent connections in PHP

wn, though I'm unaware of any fix. I think it's best to use pgbouncer and plain connect ATM. Additionally, as mentioned earlier, using pconnect under the Apache webserver is not a good idea at all, at least not with it's current architecture. -- Regards, Hannes Dorbath -

Re: [GENERAL] Persistent connections in PHP

? And even if it does, it will still held its own copy? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PostgreSQL clustering (shared disk)

te of resources, as you can't have active/active with PostgreSQL anyway. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] CREATE RULE.. RETURNING?

ghten me about the exact syntax to use this feature? I just end up with syntax errors. Thanks in advance. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] PostgreSQL clustering (shared disk)

is something you do in months, not days, at least if you want to do it right. There is so much that can go wrong, and so much to learn. Keep it simple. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL clustering (shared disk)

ink a discussion about that with the DRBD developers would be very useful for many users searching for a solution to replicate PostgreSQL, so I'm cross posting this to DRBD list. Maybe you can make clear in detail what requirements PostgreSQL has. -- Regards, Hann

Re: [GENERAL] Seeking datacenter PITR backup procedures [RESENDING]

egards, Hannes Dorbath ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] CPU load high

? What does iostat -dm 1 say say under load? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message

Re: [GENERAL] Apache + PHP + Postgres Interaction

ns would > be expected. It's broken because persistent connections get randomly garbage collected where they should not. So broken in the sense of bugged. Expect connections to die for no reason, especially under load. -- Best regards, Hannes Dorbath --

Re: [GENERAL] Apache + PHP + Postgres Interaction

On 24.08.2007 02:43, Bill Moran wrote: Hannes Dorbath <[EMAIL PROTECTED]> wrote: Bill Moran wrote: I guess I just feel that "broken" is a bit of a harsh term. If your expectations are for full-blown connection management from pconnect(), then you will be disappointed. If you

Re: [GENERAL] Apache + PHP + Postgres Interaction

On 24.08.2007 00:43, Hannes Dorbath wrote: Bill Moran wrote: I guess I just feel that "broken" is a bit of a harsh term. If your expectations are for full-blown connection management from pconnect(), then you will be disappointed. If you take it for what it is: persistent connect

Re: [GENERAL] Apache + PHP + Postgres Interaction

why it might be hard to verify that you are not hit by this bug, as in your environment there is a native fluctuation. In an FCGI environment however, you will notice this immediatelly, as the number of childs / workers is usually fixed and something must be broken if connection come and go.

Re: [GENERAL] Install on 32 or 64 bit Linux?

virtualisation is not more what you want. OpenVZ is a good example. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Connection Pooling directly on Postgres Server

s via FCGI. Each worker keeps a persistent connection to PG and load is distributed over the workers. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] about pgpool question

ur PG instance was listening on. Then configure PG to listen on some other port and tell pgpool about it. Limit connections to PG to localhost in pg_hba.conf, restart. If in doubt, strace it. -- Regards, Hannes Dorbath ---(end of broadcast)--- T

Re: [GENERAL] Foreign Key for PHP serialized data - possible?

tb1_column rows will > get changed in the above example row to: > a:5:{i:0;s:1:"9";i:1;s:2:"24";i:2;s:2:"11";i:3;s:2:"100";i:4;s:2:"10";} No offense, but that sounds like sick application design. Anyway, a plphp trigge

[GENERAL] TSearch chain dictionaries

I'm sure that is covered somewhere, but I failed to locate it. Is it not possible to chain dicts? Feed output from iSpell to a stemmer for example. Thanks. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Create artificial key without temp sequence

I need to create an artificial key, something that numbers rows of a record set. I used to use temp sequences for that, but as I'm inside pl/pgsql, its OID cache constantly bites me. What other options are there? Thanks in advance. -- Regards, Hannes Dorbath --

Re: [GENERAL] Raid Chunk Sizes for DSS type DB

I know MD RAID 1 does, MD RAID 5 does not, I don't know about MD RAID 10. If it does not, make sure you have an UPS. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Index trouble with 8.3b4

f; SET hannes=> hannes=> SELECT hannes-> f.id, hannes-> COUNT(f.id) hannes-> FROM hannes-> public.fts f hannes-> GROUP BY hannes-> f.id hannes-> HAVING hannes-> COUNT(f.id) > 1; id | count +--- (0 rows) Where are they? I'm a bit

Re: [GENERAL] Index trouble with 8.3b4

color and formating codes as well as other garbage. So anything else than a well formed text document. I cleaned it a bit with -f UTF-8 -t UTF-8 -c to make it import at all. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 3: Have you c

[GENERAL] Segmentation fault with 8.3 FTS ISpell

child postgres[14847]: [7-1] LOG: autovacuum launcher started Jan 15 11:32:55 brainchild postgres[14788]: [7-1] LOG: database system is ready to accept connections -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

Alvaro Herrera wrote: Can you please provide a backtrace from gdb? I hope that contains it: http://theendofthetunnel.de/backtrace.log It'd be nice to have text string which cause segfault and sql script for configuration. Yes, I'll try to catch the row. -- Best regards, Hann

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

Hannes Dorbath wrote: Yes, I'll try to catch the row. I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on the table to catch the row ID where it fails. The row ID is never the same. Neither can I reproduce it when I use the last reported row ID. Is NOTICE lo

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

tual machine and grant SSH access to it. The problem is that I'm running out of time. I'm probably not able to do it before friday :( Is there anything quick I can do? Can I make the backtrace more meaningful by dropping -O2 or add -ggdb? Add some debug to SplitToVariants? -- Best rega

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

believe that matters were reversed? In short, as we often dream that we dream, heaping dream upon dream, may it not be that this half of our life, wherein we think ourselves awake, is itself only a dream on which the others are grafted, from which we wake at death, during which we have as few princ

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

to the rich, that, if they do it not in the sight of God, they depart from the command of religion. SECTION VI: THE PHILOSOPHERS 339. I can well conceive a man without hands, feet, head (for it is only experience which teaches us that the head is more necessary than feet).

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

with the imagination that it is, therefore, obscure and, on the contrary, that what is to prove it is clear, and so we understand it easily. 41. Epigrams of Martial.--Man loves malice, but not against one-eyed men nor the unfortunate, but against the fortunate and proud. People are mistaken in thi

Re: [GENERAL] [OT] RAID controllers blocking one another?

, Hannes Dorbath ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] [OT] RAID controllers blocking one another?

.3ware.com/userregistration.asp?uType=eUser&boolCompany=1 and place a ticket. Though let us know when you got that solved please. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] [OT] RAID controllers blocking one another?

pure sequential benchmark load. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] [OT] RAID controllers blocking one another?

r on RAID 5/6. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] [OT] RAID controllers blocking one another?

pure sequential benchmark load. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] [OT] RAID controllers blocking one another?

2 more things: Get BBUs for the controllers (If you have not already). Upgrade to the latest 3ware firmware (code set 9.4.2). There was data corruption bug with RAID 6. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you

Re: [GENERAL] PHP and Postgres arrays

n use the build in function array_to_string: http://www.postgresql.org/docs/8.3/static/functions-array.html -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an

[GENERAL] TSearch: CLUSTER using GIST, query using GIN?

regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] TSearch: CLUSTER using GIST, query using GIN?

I though I could improve that by moving similar rows physically closer together. It's static data, it won't change at all. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

[GENERAL] Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?

el tuning parameters from the customer because we aren't expecting "power" users). Tune for your hardware, ram, disc array and config. Not for specific workload. There is no way the initdb defaults can be sane for any production setup. -- Best regards, Hannes Dorbath -

Re: [GENERAL] Trouble with Mixed UTF-8 and Latin1 data

pl/pgsql. http://www.postgresql.org/docs/8.3/interactive/functions-string.html http://www.postgresql.org/docs/8.3/interactive/plpgsql-control-structures.html -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 3: Have you checked our

Re: [GENERAL] taking actions on rollback (PHP)

-- Best regards, Hannes Dorbath -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] SQL window functions

What is the state of SQL window functions in PostgreSQL? rank(), dense_rank() over() etc? Is there work done or planed to add those to PostgreSQL? Is there experimental code? -- Best regards, Hannes Dorbath -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] SQL window functions

Roberts, Jon wrote: Greenplum has it. Maybe they are planning on adding it to Bizgres or PostgreSQL. Sadly Bizgres seems kinda stalled. Latest news is from 2006.06.09. I doubt GP is still maintaining it at all.. -- Best regards, Hannes Dorbath -- Sent via pgsql-general mailing list

Re: [GENERAL] Question about VACUUM

nce_work_mem to at least 256 MB and lower shared_buffers a bit. It should be OK to Ctrl-C a vacuum task in psql. -- Best regards, Hannes Dorbath -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Execute Shell script after insert

he following project useful: http://plsh.projects.postgresql.org/ It adds sh as a procedural language to your PostgreSQL installation. Please be aware that there are the same security concerns as with all other untrusted procedural languages. -- Best regards, Hannes Dorbath -- Sent via pgsql-general mailing list

Re: [GENERAL] EXECUTE in trigger functions.

Y$ > LANGUAGE 'plpgsql' > > This would obviously be very useful for partitioning - however if I try > this I get: Execute does execute a given string of SQL. To my knowledge there is no way you can pass new.* to that statement. What should work is to use prepare and bind all fie

[GENERAL] PITRTools: Bring up warm standby -> unexpected pageaddr

Hi, I'm trying to setup a warm standby using PITRTools. Environment is CentOS 5.2 x86_64 and PG 8.3.6 from yum.pgsqlrpms.org. As far as I can tell everything seems to work as expected. After a successful base backup and issuing cmd_standby -S the standby goes into constant recovery mode and happ

[GENERAL] Postmaster running out of discspace; Data corruption?

Hi, one of our servers did accidently run out of discspace during a huge data load. Postmaster closed the connection with `no space left on device, cannot write x_log' or something similar. We have fsync=false on that machine. Do we have to fear data corruption? Postmaster continued as normal (

Re: [GENERAL] Postmaster running out of discspace; Data corruption?

ok :) Thank you On 05.04.2005 18:11, Tom Lane wrote: Hannes Dorbath <[EMAIL PROTECTED]> writes: one of our servers did accidently run out of discspace during a huge data load. Postmaster closed the connection with `no space left on device, cannot write x_log' or something similar. We

[GENERAL] artificial keys or not?

we have lots of small relations that only consist of a few attributes. like in an ecommerce app we have relations like: payment_methods payment_methods_lang delivery_types delivery_types_lang basket_states basket_states_lang payment_methods, delivery_types, basket_states mostly just consist of fo

Re: [GENERAL] psqlODBC and Access

On 23.04.2005 03:23, [EMAIL PROTECTED] wrote: Should I not use MONEY in defining such fields to be used with ACCESS? Is there a different TYPE that I should use in my definition? Thanks! From http://www.postgresql.org/docs/8.0/interactive/datatype-money.html "The money type is deprecated. Use

Re: [GENERAL] PHP and Postgresql on Windows

On 23.04.2005 00:03, David Roussel wrote: Try PEAR DB. http://pear.php.net/package/DB It's a database abstraction layer, which means that you can change DB later, with less hasle. http://www.powerpostgresql.com/Downloads/database_depends_public.swf :) I really dislike db abstraction layers and PEA

Re: [GENERAL] Query Designer

The SQL generated by tools like that is mostly neither performant nor readable in particular. Better learn basic SQL and use an editor with keyboard templates. That way you'll be writing your statements even faster than cicking arround in some stupid GUI ;) And yes, PGExplorer is the only FREE

[GENERAL] Persistent Connections in Webserver Environment

Hi, as the subject says I need some advice on setting up connection handling to PG in a webserver environment. It's a typical dual Xeon FreeBSD box running Apache2 with mod_php5 and PG 8. About 20 different applications (ecommerce systems) will be running on this box. Each app resides in it's o

Re: [GENERAL] Persistent Connections in Webserver Environment

he server side makes altering the schema later easier (?). This should be a balance between having cached connections (VERY important for any even slightly-loaded system, in my very limited experience) and having robust auditing. Sean - Original Message - From: "Hannes Dorbath

Re: [GENERAL] Persistent Connections in Webserver Environment

On 02.05.2005 16:41, Marco Colombo wrote: Have you measured the real gain in using persistent connections at all? I measured it about one year ago on a linux box. Swichting from multi-user-pg_connect to single-user-pg_pconnect was a big improvment on that box -- 50% and more on pages with just 1-

Re: [GENERAL] Persistent Connections in Webserver Environment

On 02.05.2005 16:41, Marco Colombo wrote: Have you measured the real gain in using persistent connections at all? As simple as possible: start(); pg_pconnect('host=myhost dbname=database user=user'); pg_query("SET search_path TO myschema;"); $q = "SELECT u.login FROM users WHERE u.user_id = 1;"; $q

Re: [GENERAL] Persistent Connections in Webserver Environment

On 02.05.2005 17:32, Hannes Dorbath wrote: $q = "SELECT u.login FROM users WHERE u.user_id = 1;"; Sorry, it should read: $q = "SELECT u.login FROM users u WHERE u.user_id = 1;"; I accidently removed the "u" after users while removing line breaks to

Re: [GENERAL] Persistent Connections in Webserver Environment

On 02.05.2005 17:41, Scott Marlowe wrote: But if the average PHP script takes 50 milliseconds to start up and 100 milliseconds to run, then either one is still pretty much noise. Yeah, _IF_ :) Our scripts reside precompiled in a bytecode cache so there just isn't much start up time ;) I just repl

Re: [GENERAL] Persistent Connections in Webserver Environment

On 02.05.2005 18:33, Marco Colombo wrote: #1 Golden Rule for optimizing: - Don't. (Expecially when it causes _real_ troubles elsewhere.) hmm.. :/ I'll do some more meaningful testing on server load this night.. Thanks so far! ---(end of broadcast)---

[GENERAL] Call dynamic PL/PGSQL function

Hi, what's the best way in pl/pgsql to call a function with a dynamic name from inside another pl/plsql function? like.. SELECT INTO function_name name FROM functions WHERE bar; EXECUTE function_name..?? Thanks in advance ---(end of broadcast)--

Re: [GENERAL] Function returning any (tuple) type

On 15.07.2005 08:51, Ezequiel Tolnay wrote: The main problem I see is that the funcitions in PostgreSQL seem to be always bound to a particular result datatype. Is there a way to circumvent this? I tried to find a solution for this as well some time ago. I don't believe there is a practical

Re: [GENERAL] Looking for a good ERD Tool

On 07.07.2005 06:23, Rob Brenart wrote: Anyway, would like to find a similar tool specifically designed for PostgreSQL... does one exist or is it a futile search? I tested almost anything that is out there over the years.. http://www.casestudio.com Works perfect with PG8, fully script- and e

[GENERAL] PG based wiki engine

Is there such a thing? PHP would be preferable, I don't want to maintain a MySQL-Server for such a small thing.. Thanks in advance ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] EXCEPTION in pl/pgsql

On 19.07.2005 20:56, Craig Bryden wrote: What is the syntax if I want to use the exception clause in a pl/pgsql function, but am not looking for a particular error. Kind of like a "any error" type thing. 35.7.5. Trapping Errors http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-str

[GENERAL] Need help with data validation..

Hi, we are refactoring a larger merchandise management system atm. It's a more complex schema with about 120 relations. In the current system we have parts of the bussines logic in the DBMS and other parts, that we had problems implementing in pl/pgsql, in the app itself. Our goal is to move

[GENERAL] temp_buffers

Can someone give me a little info on what this setting does in 8.1 beta? Thanks ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Php abstraction layers

DBMS work easier. To prevent SQL injections in PHP5.1, take a look at pg_query_params(). Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Php abstraction layers

t. On the other hand it locks you out from special API features / functions of PG. I wouldn't bother with it, especially not in your case. Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Php abstraction layers

On 31.08.2005 05:00, Greg Stark wrote: > My understanding is that PDO is the way and the light. Use PDO. Maybe you could provide some arguments on why it should be that? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] Postgresql version

8.0.3 On 31.08.2005 10:43, philip johnson wrote: What version would you recommend to use for a new installation: 8.0.x or 7.4.x ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Need for java based web admin tool

HTTP connection. EMS Postgres Manager is one of them and the lite versions are free. http://www.sqlmanager.net -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives?

  1   2   3   >