Martijn van Oosterhout kleptog@svana.org writes:
It's a fairly corner case feature, only for the case where you're
looking for the existance of an index key but don't want any other
data. I don't personally have any queries that could use such a
construct, though maybe I'm missing the point.
NTPT wrote:
3: One process, multiple threads, all threads share the same one
persitant connection. Because one thread serve one request in present
time, but threads can run concurently (AFIAK ), I am affraid, that
multiple transactions over the single connection in this scenario will
Hi,I have a question. How is using LIMIT in
SELECT on the application layer. Create temprorary table before applyes
LIMIT ? Exists any way for don't create temporary table with all records
?thank you foryour answers
LADiS
Hello,
I'm a new user (novice) of this database. I would like to optimise it...
I've already created indexes...
I see that it is possible to use 'Postmaster' in order to...
But how can I use it? I don't know... I'm using Version 8 with Windows XP
Pro.
Thanks to help me because it's working too
On Mon, 7 Mar 2005 12:13:37 +0100, Ali B. [EMAIL PROTECTED] wrote:
Hello,
I'm a new user (novice) of this database. I would like to optimise it...
I've already created indexes...
I see that it is possible to use 'Postmaster' in order to...
But how can I use it? I don't know... I'm using
On 2/6/2005 4:31 PM, Greg Stark wrote:
Jan Wieck [EMAIL PROTECTED] writes:
No, Peter.
Posting a vulnerability on a public mailing list before there is a known fix
for it means that you put everyone who has that vulnerability into jeopardy.
Vulnerabilities are a special breed of bugs and need to be
Title: number of rows in a cursor
hi
is it possible to know the number of rows into a cursor ? does any function exists ?
thanks in advance
Will
On Mon, Mar 07, 2005 at 11:31:06AM +0100, Ladislav Linhart wrote:
I have a question. How is using LIMIT in SELECT on the application layer.
Create temprorary table before applyes LIMIT ? Exists any way for don't
create temporary table with all records ?
Could you describe what you're trying
On Mon, Mar 07, 2005 at 05:06:19PM +0100, FERREIRA William (COFRAMI) wrote:
is it possible to know the number of rows into a cursor ? does any function
exists ?
Not without scanning the result. See previous discussion:
http://archives.postgresql.org/pgsql-general/2005-01/msg01264.php
hello,
Is it possible to restore a DB Schema in a different schema but in the
same Database? or restore the schema with a different name? or restore
a set of objects into a different schema from where they were
backed-up?
thanks in advance
Hugo
---(end of
On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada [EMAIL PROTECTED] wrote:
hello,
Is it possible to restore a DB Schema in a different schema but in the
same Database? or restore the schema with a different name? or restore
a set of objects into a different schema from where they were
It's a fairly corner case feature, only for the case where you're
looking for the existance of an index key but don't want any other
data. I don't personally have any queries that could use such a
construct, though maybe I'm missing the point.
I understand the difficulty of implementation
Im interested in comparing the performance of postgresql
and mysql
on various combinations of user loads and database sizes.
I have seen
a few statements to the effect of mysql is faster for
small, low use
applications, but postgresql is better for bigger stuff.
I would like
to run
Rick Schumeyer wrote:
I'm interested in comparing the performance of postgresql and mysql
on various combinations of user loads and database sizes. I have seen
a few statements to the effect of mysql is faster for small, low use
applications, but postgresql is better for bigger stuff. I would
On Mon, 2005-03-07 at 12:00, Rick Schumeyer wrote:
Im interested in comparing the performance of postgresql and mysql
on various combinations of user loads and database sizes. I have seen
a few statements to the effect of mysql is faster for small, low use
applications, but postgresql
On Mon, 2005-03-07 at 13:35 -0600, Scott Marlowe wrote:
Tune both reasonably according the the best practices for each database.
Also, you should consult people on the MySQL lists to make sure it's
being tuned properly as well. And make sure both databases have access
to the same hardware
Matthew,
This is from long ago, but I've finally had some time to continue to
investigate the problem of CPU spikes in pg_autovacuum. update_db_list
is provably one of the culprits, but it doesn't seem to be the only
one.
In looking through the code, it doesn't seem as though any vacuuming
unsuscribe
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
---(end of broadcast)---
TIP 2: you can get off all lists
Disclaimer:
This electronic transmission and any files attached to it are strictly
confidential and intended solely for the addressee. If you are not
the intended addressee, you must not disclose, copy or take any
Hope this is the correct group.
I am running 8.0.1 on XP P4 2.6 1GB for dev work
and the following simple query takes 5+ minutes
to complete. Would like to get this down to 2-3 seconds.
Other RDBMS complete it in 1 second.
select i.internalid, c.code
from local.internal i
inner join country.ip
Hi all, i am trying to restore a database, the dump is produced under
linux using pg_dump, and i get the following error every time:
ERROR: missing data for column xxx
CONTEXT: COPY table_yyy, line 18986: 18833 ?
I can restore the dump under linux just fine, both postgresql (under
win32/linux)
Sorry.
I didn't know which list best served general installation questions for the
Windows version. My question has been answered. Thanks for your attention.
Regards,
Hagop
-Original Message-
From: Reini Urban [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 06, 2005 7:27 AM
To: Hagop H.
Hello,
I have a question about inherited tables w/r to triggers... Hopefully
this will make some sense... (I'll try to keep the schema example as
simple as possible):
Given the follow schema/tables:
-- public stuff
SET search_path = public, pg_catalog;
CREATE TABLE customer(
customer_id
Hello,
Sorry, I forgot the trigger:
-- public stuff
SET search_path = public, pg_catalog;
CREATE TABLE customer(
customer_id SERIAL,
customer_notification INTEGER,
CONSTRAINT customer_notification CHECK notification = 0) OR
(notification = 1)) OR (notification = 2))),
);
CREATE
24 matches
Mail list logo