y this:SELECT w2.* FROM ( SELECT name, MAX(startdate) AS startdate FROM worker GROUP BY name ) AS w1 JOIN worker AS w2 ON (w1.name = w2.name AND w1.startdate = w2.startdate);
sfer it from the temp_table toagain only something like 10
minutes. Can it be that the cast takes up so much more time than
when reading and transferring 2 million lines?
--
Seeya...Q
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
_ / Quinton
provide the actual schema of tables and rules that
are involved in the query in question.
Q <[EMAIL PROTECTED]> wrote on 07/19/06 4:37 am:
On 19/07/2006, at 4:24 AM, Christian Rengstl wrote:
now finally after a long time i have the query plan for the whole
filled table. I hope somebo
esn't cause this huge
performance problem?
That is hard to say unless you post the rule and table schema you are
currently using.
Q <[EMAIL PROTECTED]> wrote on 07/19/06 11:54 am:
On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
The analyze is from the exact query and i dro
ly want to give up the inheritance design. is there a way
to maintain the inheritance that doesn't cause this huge
performance problem?
When you say "now everything finished within 20 minutes", what did
you actually do to achieve this?
--
Seeya...Q
-=-=-=-=-=-=-=-=-=-
rocessor_path (cost=0.00..6900.17 rows=284617
width=92)
(1 row)
Please try running 'analyze' on the tables first and then rerun these
queries as 'explain analyze' instead so you can see the difference
between what the planner expects compared
due to that thing.
I tried to re index them but is not working. Any ideas ?
Thanks
Q
Ps.
I tried to start the server in stand alone and reindex all (used the -P
command to disable the indexed but it didn't work) any ideas ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
, where in the world is the pgdump for 8.2 -
I can't find it.
pg_dump, pg_dumpall are all in /usr/bin but where are the 8.2 ones ?
TIA,
Q
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
What ways are there to limit the sizes of a database?
Thx
Q Beukes
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQEVAwUBRF8oErEDZDQ16UzTAQJbsAf+L8+RijP
is not what it was, which makes
restoring backups quite an effort.
regards
Q Beukes
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
iQEVAwUBRNM+lLEDZDQ16UzTAQIBIggAv3XxXa2HZ4ZU0i0Zu738r4567cgk5trr
/ZGLCdXOSY2wvOtSDtsAVD/rMZXwPEsPfy4M2u0inllr0Uq2uQ1pA4/+fohtqPq5
XPCv5G3wLFcOJR7NpjKA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You must have missed one, because:
root=# \set tv1 '\'testval\''
root=# insert into test values(:tv1);
INSERT 0 1
root=#
Ilja Golshtein wrote:
> Hello!
>
> Is there any way to have psql variable in apostrophes?
>
> The idea is to do something like t
copyright for distribution terms
>\h for help with SQL commands
>\? for help on internal slash commands
> \g or terminate with semicolon to execute query
>\q to quit
>
> test5=# select '01-10-2000'::date;
> ?column?
> --
g file.
CONFIGURING
==
+ as postgres super user:
createlang plperl [database]
NOTES ON USAGE
==
+ Use q[], qq[], and qw[] instead of single quotes in
function definitions.
+ When using escape sequences, you must backslash you
On Wed, 20 Sep 2000 17:54:40 -0400, Joe Kislo wrote:
> > you should not use the OID value for application level work. for one thing,
> > it's not portable, and if you rebuild the database it'll change. you should
> > consider it a strictly internal value.
>
> Hmm, I think you missed what
to change.
in other words your perl script should "use DBI;" and
not mention DBD::Pg at all.
try this:
use DBI;
$user = '';
$pass = '';
$dburl = ''; # should be: dbi:Pg:dbname=[your database name]
$db = DBI->connect($dburl, $user, $pass, {AutoCommit=>0}
in effect, this turns the filesystem into a "poor-mans" balanced tree.
the rdbms gives you a "rich-mans" balanced tree, but along with the
overhead of the rdbms.
cheers
--e--
On Thu, 21 Sep 2000 15:20:39 +0300, Alessio Bragadini wrote:
> Neil Conway wrote:
>
> > > a BLOB. Conversely, Un
, you ensure the rdbms will process them in
the order you specify.
the other statement you quote from the docs (which is not
entirely clear to me without context) seems to refer to
the fact that a sequence will never return the same number
twice when nextval('seq_name') is called.
HTH
-
On Wed, 20 Sep 2000 21:24:17 -0400, Neil Conway wrote:
> I believe he is using straight Pg - the perl interface to Postgres.
> AFAIK, that's independant of DBI::Pg, which is the Postgres
> driver for DBI.
>
ahhh! "i see" said the blind man :)
> I agree with you, however: I've found DBD::Pg q
when i did what's described below, i had no problems at all with
PL/Perl (and, in fact, am using it for a couple of triggers that
are lightly used in a production environment)
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/pl/plperl/README?rev=1.2&content-type=text/x-cvsweb-
markup
you can
n.b. to clarify, i got PL/Perl working on RH Linux 6.2
am in the process of attempting to get it working on NT.
==BEGIN FORWARDED MESSAGE==
when i did what's described below, i had no problems at all with
PL/Perl (and, in fact, am using it for a couple of trig
According to my copy of SQL For Smarties by Joe Celko (2nd ed, p. 411):
> The UNION removes all duplicate rows from the results and does
> not care from which table the duplicate rows came. We could
> use this feature to write a query to remove duplicates from a
> table:
>(TABLE tableA)
>
According to my copy of SQL For Smarties by Joe Celko (2nd ed, p. 411):
> The UNION removes all duplicate rows from the results and does
> not care from which table the duplicate rows came. We could
> use this feature to write a query to remove duplicates from a
> table:
>(TABLE tableA)
>
On Tue, 12 Dec 2000 12:04:46 +0100, Roger Wernersson wrote:
>
> I can't BEGIN - SELECT FOR UPDATE - INSERT or UPDATE - COMMIT as someone
> might insert after my SELECT and before my INSERT.
>
correct me if i'm wrong, but a select for update locks the table for
an insert or an update until the
Hi:
Have this curious situation and would like some help from you:
Create an employee table:
CREATE TABLE employee(
id_employee SERIAL PRIMARY KEY,
sex CHAR(1) DEFAULT 'm' CHECK(sex = 'f' OR sex = 'm'),
start_date DATE NOT NULL,
charge VARCHAR(50) NOT NULL,
last_name VARCHAR(50
Hi:
Wonder if any of you know how to setup a postgreSQL server as a windows 2000 service
or have a URL or document on how to do it.
Thank you
---
Luis Magaña
Gnovus Networks & Software
www.gnovus.com
Tel. +52 (7) 4422425
[EMAIL PROTECTED]
Hello:
It is possible to display error messages from PostgreSQL in other languages rather
than English ?, if it is possible, how can
achieve that. I love this RDBMS but this seems to be a problem for us in using it
with our customers. Any help or answer will
be aprecciated.
Thank yo in adv
David Wheeler wrote:
[...]
Well, I didn't have an unconditional update rule, so I added one without
removing the other two:
CREATE RULE nothing_one AS
ON INSERT TO one DO INSTEAD NOTHING;
And it worked! Now I can have an insert do an INSERT or UPDATE on
another table magically.
But my question
Hi list,
some time ago, there was a discussion about oid wraparound. See
http://archives.postgresql.org/pgsql-general/2002-10/msg00561.php .
Those days, we had PostgreSQL 7.1 and 7.2, and we had to be careful
oids approaching 2^32 (2.14 billion)
Now, we have 8.0. What does the situation look li
Thanks, Neil.
Hubert Fröhlich wrote:
Those days, we had PostgreSQL 7.1 and 7.2, and we had to be careful
oids approaching 2^32 (2.14 billion)
Now, we have 8.0. What does the situation look like?
With the default settings, there is exactly the same risk of OID
wraparound as in earlier releases.
Stephane Bortzmeyer wrote:
On Wed, Apr 27, 2005 at 10:26:30AM -0400,
Tom Lane <[EMAIL PROTECTED]> wrote
a message of 9 lines which said:
If that's what you want, declare it as UNIQUE not PRIMARY KEY.
As shown by Patrick TJ McPhee, it does not work:
tests=> create table x (
tests(>name TE
Hi.
I would like to implement simple users/user groups
administration from MS Access. I have already set user groups and permissions to
different objects inside the database. Now, I would like to enable creating new
users and putting them in previosly pre-defined groups, through Access
inter
Hello.
Till now I've been working with Postgres only
through pgAdminIII. Postgres is installed on WIndows XP.
Now I need to use pg_dumpall. I have found folder
with different Postgres aplications, placed in C:\Program
Files\PostgreSQL\8.0\bin.
When I double-click on any of them, I am prompt
Hi.
I know that superusers are allowed to do everything
on the database, but I consider this as dangerous. I want to have some
user group with rights of creating new users and giving them some
authorizations, but without such wide power as superusers have. So,
I was thinking about two poss
Hi,
we plan to make available our database from the internet (direct tcp/ip
based connections). We want to make it as secure as possible. There are a
few users who could access the database, but we want to block any other
users to access.
Our plans are:
- using encripted (ssl) connections - sin
On Sun, 2005-04-24 at 09:49 -0700, Rich Shepard wrote:
>I'm converting mysql tables to postgres. One of the tables has this:
>
>PRIMARY KEY (org_id, contact_id),
>KEY contact (contact_id, org_id)
>
>Is there really a difference in the two indices if the sequence of fields
> is rev
On Mon, 2005-04-25 at 03:38 +0530, Rajiv Verma wrote:
> I'm accessing postgres database through tomcat 4.3.1.
> I'm able to execute the select and update query through my application
> but Insert query is giving following SQLException :
> Connection is closed. Operation is not permitted.
looks li
On Tue, 2005-04-26 at 13:58 -0400, Ying Lu wrote:
> select * from A left join B using (id) where A.type='apple' and
> A.isExport=true;
>
> "id" is the primary key for both table A & B. If index (type, isExport)
> has been created for table A. In the above query, will this index works?
simplest
37 matches
Mail list logo
