-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/13/06 10:47, John D. Burger wrote:
> Erik Jones wrote:
>
[snip]
> But with both approaches, the planner is just using the static
> statistics gathered by ANALYZE to estimate the cost of each candidate
> plan, and these statistics are based on sa
> If I send something like 25 / '5' I get the result, 5
> but if I send 25 / '0' I get null (division_by_zero)
> or when I send 25 / 'textcrap' I get null too
You might want to look at pl/pgsql exception handlers:
http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGS
Hi there,
I am new in this group and I've been working a lot in this function
but it didnt work good enought until now. Here is the thing: I use some
sql strings that calcultes a coll with another and I get the results.
For exemple I have two tables that has many float, texts or numeric coll
Jim C. Nasby wrote:
> Just recording the query plan and actual vs estimated rowcounts would
> be a good start, though. And useful to DBA's, provided you had some
> means to query against it.
If the DBMS stores the incoming query (or some parsed version of it) and
identifies frequency of usage
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/14/06 18:04, Reece Hart wrote:
> On Fri, 2006-10-13 at 14:54 +0100, Richard Huxton wrote:
>> Greg's mostly right, but the Vic-20 port is available as a type-in
>> program listing in issue 3 of "Your Computer".
>
> Don't bother. I already typed i
On Fri, 2006-10-13 at 14:54 +0100, Richard Huxton wrote:
Greg's mostly right, but the Vic-20 port is available as a type-in
program listing in issue 3 of "Your Computer".
Don't bother. I already typed it in and have it on cassette tape here somewhere. I'll send it via parcel post w
On 10/14/06, Chris Mair <[EMAIL PROTECTED]> wrote:
Ok,
I did some tests at last on this using the above 3 suggestions.
I ran on 8.1.4 on Linux with fsync=off and did 300k updates bundled
into 100 updates / 1 transaction (100 turned out to be a sweeter
spot than 1000).
My postgresql 'magic numbe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/14/06 14:35, Michael Fuhr wrote:
> On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
>> What is the use case for a READ ONLY transaction?
>
> I use read-only transactions as a safety net for interactive sessions
> when I want to a
am Sat, dem 14.10.2006, um 13:35:21 -0600 mailte Michael Fuhr folgendes:
> On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
> > What is the use case for a READ ONLY transaction?
>
> I use read-only transactions as a safety net for interactive sessions
> when I want to avoid modify
On Sat, Oct 14, 2006 at 03:42:48PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
> >> What is the use case for a READ ONLY transaction?
>
> > It would be handy for things like pgpool and Continuent, which coul
David Fetter <[EMAIL PROTECTED]> writes:
> On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
>> What is the use case for a READ ONLY transaction?
> It would be handy for things like pgpool and Continuent, which could
> reliably distinguish up front the difference between a transacti
On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
> What is the use case for a READ ONLY transaction?
I use read-only transactions as a safety net for interactive sessions
when I want to avoid modifying anything accidentally. Here's an
example:
CREATE ROLE foo LOGIN PASSWORD 'pass
On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
> Hello,
>
> Command Prompt has been teaching alot of classes lately, and one of the
> questions that I received recently was:
>
> What is the use case for a READ ONLY transaction?
It would be handy for things like pgpool and Conti
Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> What is the use case for a READ ONLY transaction?
>
>> I haven't been able to come up with a good answer. Anyone got a use case
>> for this feature? I know the community didn't implement it for giggles.
>
> No, we implemented it b
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> What is the use case for a READ ONLY transaction?
> I haven't been able to come up with a good answer. Anyone got a use case
> for this feature? I know the community didn't implement it for giggles.
No, we implemented it because it's required by the
Hello,
Command Prompt has been teaching alot of classes lately, and one of the
questions that I received recently was:
What is the use case for a READ ONLY transaction?
I haven't been able to come up with a good answer. Anyone got a use case
for this feature? I know the community didn't implemen
> I'd dare to say that if you just ran ZABBIX on 8.1 with
> autovacuum on with a shortish interval (30 sec?) you'd
> get rid of your performance problems. Time to update
> the documentation after all? ;)
I would be curious to see what would happen if you added to vacuum_*
parameters to the equati
> > it would be cool if you could at least:
> >
> > - bundle your updates into transactions of, say, 1000 updates at a time
> >i.e. wrap a BEGIN; END; around a 1000 of them
> > - run postgresql with fsync off, since you're using MyISAM
> > - run PostgreSQL at least 8, since you're running M
On Thu, Oct 12, 2006 at 01:46:53PM +0300, Stanislaw Tristan wrote:
> Thanks for the answer!
> We'll order a 2 x Opteron2xxx series (Dual Core) and the memory will be
> 16-32 Gb. This server is only for DB - non other services such as hosting,
> mail and so on.
You didn't discuss your disc config
On Thu, Oct 12, 2006 at 12:13:02AM -0400, Ye Qin wrote:
> psql: could not connect to server: Connection refused
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> Any advice?
Presumably, the server doesn't start? What does your
jef peeraer schreef:
i never thought i would be bblocked by an encoding problem :-(
My database is in LATIN1 , i have entries like this in a table called
gemeenten
Column | Type | Modifiers
---+--+
On Tue, Oct 10, 2006 at 05:16:14PM +0100, garry saddington wrote:
> On Tue, 2006-10-10 at 11:58 -0400, Tom Lane wrote:
> > garry saddington <[EMAIL PROTECTED]> writes:
> > > This definition does not insert time zone. If I use without time zone
> > > then the time zone is inserted.
> > > If I input
Andreas Kretschmer wrote:
Andreas Kretschmer <[EMAIL PROTECTED]> schrieb:
Adam <[EMAIL PROTECTED]> schrieb:
I just emptied my table and I want all my new inserts to start with a
'location_id' of '1'. The table is named "locations" with a SERIAL column
"location_id"
If you want to start at 1
[EMAIL PROTECTED] wrote on 11.10.2006 16:54:
Do a simple test to see my point:
1. create table test (id int4, aaa int4, primary key (id));
2. insert into test values (0,1);
3. Execute "update test set aaa=1 where id=0;" in an endless loop
I just did the test on PostgreSQL 7.4.12 and MySQL 5.0.2
24 matches
Mail list logo