Hello,
There is also a funny approach here with custom operators and variables
that could be adapted to build a rownum functioanlity in functions
(look for Vladimir)
http://archives.postgresql.org/pgsql-hackers/2008-11/msg00048.php
not very clean, but apparently fast
Marc Mamin
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
On Thu, Mar 26, 2009 at 5:10 PM, Scott Marlowe scott.marl...@gmail.com wrote:
It's also important to point out that writers don't necessarily block
other writers. As long as they're operating on different ranges of
the data set. You can have dozens of writers streaming data in with
On Thu, Mar 26, 2009 at 8:55 PM, David Fetter da...@fetter.org wrote:
In PostgreSQL 8.4, you'll be able to do:
SELECT
row_number() OVER (ORDER BY col1) AS i,
e.col1,
e.col2,
...
FROM ...
Good news! Better late than never :)
Until then, there are some ugly, fragile
On Fri, Mar 27, 2009 at 10:32:33AM +1300, Tim Uckun wrote:
What about running a 32bit build of PG on the 64bit machine?
How would one go about doing something like this?
Depending on your distribution you should be able to install 32bit
binaries alongside 64bit binaries; for example in
What is the path format for the i (\i) command in the SQL shell?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
What is the path format for the i (\i) command in the SQL shell?
I think it's just as anywhere else on Windows, e.g.
\i c:\path\to\file.sql
Windows support forward slashes as well, only not all Windows programs
do support that (cmd.exe for example doesn't). So, it's worth a try.
From my experience, you must use the forward slash. Using the backslash may
give you an error:
\i C:\sql\test.sql
C:: Permission denied
Instead, use
\i C:/sql/test.sql
From: Raymond O'Donnell r...@iol.ie
To: MDB mdb...@yahoo.com
Cc:
I've had lots of experience fighting with the LOAD FROM command with an
old application using an old version of Informix. When the data to be
loaded is large enough, Informix (dbaccess) hits a wall. Tracking it
down with tools generally shows that zillions of locks are accumulating.
The system
On Fri, Mar 27, 2009 at 04:45:26PM +0200, Aurimas Černius wrote:
Windows support forward slashes as well, only not all Windows programs
do support that (cmd.exe for example doesn't). So, it's worth a try.
Where did you get the idea that cmd.exe doesn't support forward slashes?
It just passes
Hi all,
is possible in PostgreSQL to create query between multidatabase like Sql Server
2005?
An example:
SELECT
db1.a.id FROM db1.a
UNION
db2.b.id FROM db2.b
Where db1 is a database and db2 is another database. a is a table in
database db1 and b is a table in database db2
Best
I have a table that is partitioned on a daily basis.
Full text searches used to be respectably fast with large tables (40
million + records) but insert speed would slow down. So I went with a
partitioned approach. But now, it doesn't seem like the indexes are
being used.
Any idea why it would
On Fri, 2009-03-27 at 10:54 +0100, Hannes Dorbath wrote:
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.
This really should be on the pitrtools list:
https://lists.commandprompt.com/mailman/listinfo/pitrtools
Be
On 27/03/2009 14:28, MDB wrote:
What is the path format for the i (\i) command in the SQL shell?
I think it's just as anywhere else on Windows, e.g.
\i c:\path\to\file.sql
If there are spaces in the path you may have to enclose it in double-quotes:
\i c:\path with spaces\file.sql
Happy spring.
I am new to postgres/postgis and am trying to figure out the best way to
approach documenting metadata within postgres. Has there been anything
developed to add FGDC or Dublin Core standard metadata records into postgres
for each table within the database? Is there any program
Justin Funk fun...@iastate.edu writes:
Any idea why it would not be using the indexes?
The child table you showed us has a btree index on message_index_col,
which is useless for @@ queries. Maybe you forgot to specify the
index type while rearranging the table into partitioned form?
Thank you,
I also found you could drop the C: (e.g. /sql/test.sql) if it is on the c
drive. The backslashes on my system threw the same error..
--- On Fri, 3/27/09, John Cheng jlch...@ymail.com wrote:
From: John Cheng jlch...@ymail.com
Subject: Re: [GENERAL] Postgresql On Windows
To:
MDB wrote:
Thank you,
I also found you could drop the C: (e.g. /sql/test.sql) if it is on the c drive.
to be more precise, you can drop the C: if its the same as the current
default drive for whatever process is reading it. Windows, for legacy
reasons that date at least back to Digital
On Fri, Mar 27, 2009 at 10:32 AM, Will Rutherdale (rutherw)
ruth...@cisco.com wrote:
Incidentally, in case people are interested in hearing the follow-up to
my original message, my home-cooked benchmark with lots of processes
doing tons of updates seemed to initially show MyISAM winning over
I see. Perhaps earlier I alienated some people by talking about
transactions per second, which is not necessarily an appropriate unit.
Thanks for the tip.
-Will
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: 27 March 2009 16:08
To: Will Rutherdale
On Fri, Mar 27, 2009 at 2:27 PM, Will Rutherdale (rutherw)
ruth...@cisco.com wrote:
I see. Perhaps earlier I alienated some people by talking about
transactions per second, which is not necessarily an appropriate unit.
Hard to say, tps is still important. A lot of loads need to change
one
I had given reply abt windows
From: Shoaib Mir shoaib...@gmail.com
To: Dhaval Jaiswal bablu_postg...@yahoo.com
Cc: Kent Tong k...@cpttm.org.mo; pgsql-general@postgresql.org
Sent: Friday, March 27, 2009 4:47:43 AM
Subject: Re: [GENERAL] how to specify the
log_statement = none/ddl/mode/all
log_min_duration = value -- to log query consumes more than set value
--
Thanks Regards
Dhaval Jaiswal
From: Raymond O'Donnell r...@iol.ie
To: ray ray.jos...@cdicorp.com
Cc: pgsql-general@postgresql.org
Sent:
Hi Mauro,
Not possible in PostgreSQL.
However, you can use dblink for creating query between multidatabase as
given below:
select empno from dblink('dbname=edb','SELECT empno from emp') as
emp(empno numeric)
union
select empno from dblink('dbname=enterprisedb','SELECT empno from emp')
as
select a.relname, a.relowner, b.oid, b.rolname from pg_class a, pg_roles b
where relname like 'table_name' and a.relowner=b.oid and relkind = 'r';
\dt+
--
Thanks Regards
Dhaval Jaiswal
From: Roderick A. Anderson raand...@cyber-office.net
To: PostgreSQL
postgres=# \i C:/dj1.sql;
If there are space.
--
postgres=# \i 'C:/Program Files/PostgreSQL/8.3/bin/dj.sql';
Thanks Regards
Dhaval Jaiswal
www.enterprisedb.com
From: Raymond O'Donnell r...@iol.ie
To:
26 matches
Mail list logo