On 2/10/2010 9:41 AM, Dann Corbit wrote:
The inserts are processed via an INSERT/SELECT statement.
A custom driver has been written that performs this operation
using the COPY API.
Aaah, so it's not really sending individual INSERT statements to the
database at all, you're using COPY behind t
> -Original Message-
> From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
> Sent: Friday, October 01, 2010 6:08 PM
> To: Dann Corbit
> Cc: 'Joshua J. Kugler'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Kudos on the 64 bit PostgreSQL for Windows
>
> On 2/10/2010 2:06 AM, Dan
> -Original Message-
> From: Dann Corbit
> Sent: Friday, October 01, 2010 11:06 AM
> To: 'Joshua J. Kugler'; pgsql-general@postgresql.org
> Subject: RE: Kudos on the 64 bit PostgreSQL for Windows
>
> > -Original Message-
> > From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
> >
On 2/10/2010 5:44 AM, Scott Marlowe wrote:
On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan
wrote:
Hi All
I am planning to upgrade postgres to avoid this autovacuum problem.
From the release notes of postgres-8.1.x it seems this issue
has been solved in postgres-8.1.6 and hence upgrading
to
On 2/10/2010 2:06 AM, Dann Corbit wrote:
>> SQLite can
deliver several thousand inserts per second if inside of a transaction.
If you were only getting a few inserts per second, then you were not
using transactions, thus SQLite was on "autocommit" mode, and thus
committing after every insert, thu
Thanks a lot Scott ...
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Saturday, October 02, 2010 3:14 AM
To: tamanna madaan
Cc: Michael Glaesemann; pgsql-general@postgresql.org
Subject: Re: [GENERAL] error while autovacuuming
On Fri, Oct 1, 2010 at 2:06 PM
On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan
wrote:
> Hi All
>
> I am planning to upgrade postgres to avoid this autovacuum problem.
>
> From the release notes of postgres-8.1.x it seems this issue
> has been solved in postgres-8.1.6 and hence upgrading
> to latest 8.1 release i.e 8.1.21 will s
Andrew E. Tegenkamp wrote:
I have two tables and want to attach and return the most recent data from
the second table.
Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to
Table 1 ID), Date, and Like. I want to do a query that gets each name and
their most recent like. I ha
Hi All
I am planning to upgrade postgres to avoid this autovacuum problem.
From the release notes of postgres-8.1.x it seems this issue
has been solved in postgres-8.1.6 and hence upgrading
to latest 8.1 release i.e 8.1.21 will solve this issue.
But I was just wondering if postgres-8.4 will al
On Fri, Oct 1, 2010 at 9:13 AM, Michal Politowski wrote:
> EXPLAIN SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
1: Try running explain analyze select ... here. It's far more informative.
2: select distinct is generally slower than using group by.
>
How to see what SQL queries are associated with pg_locks, please?
Could somebody help with the query? I can then add it to
http://wiki.postgresql.org/wiki/Lock_Monitoring
Best,
-at
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
> -Original Message-
> From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
> Sent: Friday, October 01, 2010 10:36 AM
> To: pgsql-general@postgresql.org
> Cc: Dann Corbit
> Subject: Re: Kudos on the 64 bit PostgreSQL for Windows
>
> On Thursday 30 September 2010, Dann Corbit elucidated th
On Thursday 30 September 2010, Dann Corbit elucidated thus:
> I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it
> seems to perform wonderfully. I moved 1.5 million records that are 3K
> wide from SQL*Server into PostgreSQL and rebuilt 6 indexes all in
> less than 6 minutes.
> I w
On 20 Sep 2010, at 19:25, Steve Atkins wrote:
> On Sep 20, 2010, at 10:06 AM, Alban Hertroys wrote:
>> Hey all,
>>
>> I'm tossing an idea around again, namely using bit positions and values as
>> foreign key references. Let's start with a bit of background information:
>>
>> I'm currently parsin
EXPLAIN SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
QUERY PLAN
-
Aggregate (cost=1615927.27..1615927.28 rows=1 width=8)
-> Seq Scan on catalog (
I have two tables and want to attach and return the most recent data from
the second table.
Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to
Table 1 ID), Date, and Like. I want to do a query that gets each name and
their most recent like. I have a unique key setup on like
Thanks Greg. I'd had a quick look at bucardo and while it seems capable of
doing the job (or helping to do that job), I was hoping there was something
simpler. But I will have a closer look.
Have you ever evaluated rubyrep (http://www.rubyrep.org/)? It's also multi
master.
--
View this message
novnovice wrote:
My use case would involve a primary postgresql database and several
postgresql databases on disconnected notebook computers. All dbs need to be
able to support updates inserts etc; and then hopefully the replication
software would help with things like conflict resolution.
T
2010/10/1 bricklen :
> 2010/10/1 Thom Brown :
>> But to find out what indexes you'll need, getting used to reading
>> query plans will help as it will show you more than just where
>> sequentials scans are taking place. It will also show you what the
>> planner believes a query will cost compared
First of all: Thanks to all who contributed to this issue. There are
many helpful and interesting comments.
I am going to reply to Christian's first question: How did TEMP end up
with this value?
I have just scanned my installation protocol which says, that I made a
registry backup of the curren
[sorry, I didn't intend to send my prev. reply off-list]
Hello Gurjeet,
thanks for you interest! I've just summarized my problem at the
http://www.phpbb.com/community/viewtopic.php?uid=221190&f=46&t=2105913&start=0
I log protocols of card games into forum_id=5 as Anonymous user_id=1
at my site
On 10/01/2010 10:40 PM, Alexander Farber wrote:
Ouch! I've loaded my backup while being connected
to the wrong database - to the dafeult "postgres" database.
Is there a way to restore it?
Sure. Just drop it and re-create it. The "postgres" database is just a
convenience, and is typically empt
On Fri, Oct 1, 2010 at 10:52 AM, Alexander Farber <
alexander.far...@gmail.com> wrote:
> Thank you, I've created the following script which seems to work ok.
>
> I just hope, that it won't be hit by the max_stack_depth-problem
> which actually forced me to look for a custom solution -
>
>SQL E
2010/10/1 Thom Brown :
> But to find out what indexes you'll need, getting used to reading
> query plans will help as it will show you more than just where
> sequentials scans are taking place. It will also show you what the
> planner believes a query will cost compared to how much it actually
> c
Ouch! I've loaded my backup while being connected
to the wrong database - to the dafeult "postgres" database.
Is there a way to restore it? I currently have:
postgres=# \l
List of databases
Name| Owner | Encoding
---+--+--
postgres | postgres | UTF8
ph
On Friday 01 October 2010 7:13:09 am Andrus wrote:
> >> Where to find installation packages for Debian and Ubuntu ?
> >
> > Installers can be downloaded in StackBuilder.
>
> How to run StackBuilder from Debian bash command line ?
>
> Andrus.
http://www.enterprisedb.com/learning/pginst_guide.do
--
Rob Sargent skrev 2010-10-01 15.43:
Then to get all statements would one simply set log_min_duration to some
arbitrarily small value?
From default postgresql.conf comments:
-1 is disabled, 0 logs all statements and their durations, > 0 logs only
statements running at least this number of mi
On Fri, Oct 1, 2010 at 3:13 PM, Andrus wrote:
>>> Where to find installation packages for Debian and Ubuntu ?
>>
>> Installers can be downloaded in StackBuilder.
>
> How to run StackBuilder from Debian bash command line ?
On RHEL/CentOS, I'd use the following from a root command prompt:
/opt/Pos
On Fri, Oct 1, 2010 at 10:02 AM, Adrian Klaver wrote:
> On Friday 01 October 2010 6:54:09 am Alexander Farber wrote:
> > How do you copy a column from table please?
> > I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
>
> > select topic_id from phpbb_topics where forum_id=5 and topic_poster=1
> > a
Where to find installation packages for Debian and Ubuntu ?
Installers can be downloaded in StackBuilder.
How to run StackBuilder from Debian bash command line ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
On Fri, Oct 1, 2010 at 3:04 PM, Andrus wrote:
>>> How to configure automatically Linux and Mac servers ?
>>
>> Run the tuning wizard on them?
>
> Where to find installation packages for Debian and Ubuntu ?
Installers can be downloaded in StackBuilder.
--
Dave Page
Blog: http://pgsnake.blogspot
How to configure automatically Linux and Mac servers ?
Run the tuning wizard on them?
Where to find installation packages for Debian and Ubuntu ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
On Friday 01 October 2010 6:54:09 am Alexander Farber wrote:
> How do you copy a column from table please?
> I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
>
> # psql -a -f clean-forum.sql
> start transaction;
> START TRANSACTION
> create temp table old_topics (topic_id integer) on commit delete row
Hi Alex,
Of course "select ... into" doesn't work, but how should I do it?
Can't find in http://www.postgresql.org/docs/8.1/static/
You might want to look at the CREATE TABLE AS command. You might even
use the temporary definer.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Po
How do you copy a column from table please?
I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
# psql -a -f clean-forum.sql
start transaction;
START TRANSACTION
create temp table old_topics (topic_id integer) on commit delete rows;
CREATE TABLE
create temp table old_posts (post_id integer) on commit de
On 1 October 2010 14:43, Rob Sargent wrote:
> Then to get all statements would one simply set log_min_duration to some
> arbitrarily small value?
Well, 0 will do, although if you're got a busy cluster, this'll slow
it down. Its default is -1 which means disabled.
--
Thom Brown
Twitter: @darkix
Then to get all statements would one simply set log_min_duration to some
arbitrarily small value?
On 10/01/2010 04:30 AM, Thom Brown wrote:
> 2010/10/1 Bjørn T Johansen :
>> We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
>> Navigator, where one can enable logging of SQL
On 01/10/2010 10:14, Vishnu S. wrote:
Hi,
I have trying to create a new Slony-Cluster using pgAdmin. When I
clicked the OK button the following Error message is shown.
“An error has occurred:
ERROR: could not access file "$libdir/xxid": No such file or directory”
The configured Slony-I path i
On 1/10/2010 9:24 PM, Andrus wrote:
How to configure remote servers where only port 5432 is open ?
You can't. You need to be able to modify postgresql.conf .
Why pgAdmin postgresql.conf editor does not contain automatic
configurator ?
Because nobody has written one for PgAdmin. The Enterpr
On Fri, Oct 1, 2010 at 2:24 PM, Andrus wrote:
>>> Will it set optimal configuration so that manual editing of
>>> postgresql.conf
>>> is not required ?
>
>> It will generate a starter configuration, that will be based on your
>> selected workload type and machine resources. That may be fine for
>>
Hi,
I have trying to create a new Slony-Cluster using pgAdmin. When I
clicked the OK button the following Error message is shown.
The configured Slony-I path is C:\Program Files\PostgreSQL\8.4\share (
where the slony script files are present.)
Thanks & Regards,
Vishnu S
<>
Hi,
I have trying to create a new Slony-Cluster using pgAdmin. When I
clicked the OK button the following Error message is shown.
"An error has occurred:
ERROR: could not access file "$libdir/xxid": No such file or directory"
The configured Slony-I path is C:\Program Files\Postgre
Will it set optimal configuration so that manual editing of
postgresql.conf
is not required ?
It will generate a starter configuration, that will be based on your
selected workload type and machine resources. That may be fine for
your needs, or you may need to tune it to more precisely meet th
On Fri, Oct 1, 2010 at 3:08 AM, John R Pierce wrote:
> On 09/30/10 11:58 PM, GOO Creations wrote:
>>
>> thanks for this tip, but as far as I understand it libpqtypes is not part
>> of the original lipq libary .
>> This will result in the same problem as with the Qt libraries, it will add
>> anot
On Fri, Oct 1, 2010 at 1:06 PM, Craig Ringer
wrote:
> On 10/01/2010 06:30 PM, Dave Page wrote:
>
>>> As for 2, I suspect that somewhere in the installer, it walks down the
>>> path
>>> to the TEMP directory, and fails at the junction because it cannot read
>>> the
>>> contents of its target direct
On 10/01/2010 06:51 PM, Frank Church wrote:
I want to migrate a lot of single user databases onto a single server
to allow the users to access them remotely, instead of on the
workstations. The databases are quite small and even the most heavily
used ones only have at most a few hundred records a
2010/10/1 Bjørn T Johansen :
> On Fri, 1 Oct 2010 11:30:59 +0100
> Thom Brown wrote:
>
>> 2010/10/1 Bjørn T Johansen :
>> > We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
>> > Navigator, where one can enable logging of SQL statements and then it
>> > will recommed indexe
On Fri, 1 Oct 2010 11:30:59 +0100
Thom Brown wrote:
> 2010/10/1 Bjørn T Johansen :
> > We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
> > Navigator, where one can enable logging of SQL statements and then it
> > will recommed indexes that should/could be created to incr
I want to migrate a lot of single user databases onto a single server
to allow the users to access them remotely, instead of on the
workstations. The databases are quite small and even the most heavily
used ones only have at most a few hundred records added to them
everyday.
The problem is they ha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 01/10/2010 11:53, Bjørn T Johansen a écrit :
> We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
> Navigator, where one can enable logging of SQL statements and then it will
> recommed indexes that should/could be created to
Hi all,
I might not be understanding this correctly, but does Postgres, when
VACUUM ANALYZE-ing a table, perform separate scans for each index?
And if so, is this necessary? Can't it update indexes parallel? This
would be particularly useful when rebuilding all indexes on a table.
Thanks
Thom
2010/10/1 Bjørn T Johansen :
> We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
> Navigator, where one can enable logging of SQL statements and then it will
> recommed indexes that should/could be created to increase speed...
> Does there exist a similar tool for PostgreSQL
On Fri, Oct 1, 2010 at 11:01 AM, Christian Ullrich wrote:
> * Dave Page wrote:
>
>> So, it sounds like there are two questions for me to figure out - why
>> is the installer not able to follow the link and find the files (which
>> is probably a question for BitRock), and why isn't it using the act
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable logging of SQL statements and then it will
recommed indexes that should/could be created to increase speed...
Does there exist a similar tool for PostgreSQL?
Regards,
BTJ
--
--
* Dave Page wrote:
Thats very odd, but it explains why things are going wrong -
essentially, the prerequisites are being unpacked to:
C:\Users\Administrator\AppData\Local
But the installer expects to find them in:
C:\Users\Administrator\Lokale Einstellungen\
Which is a link to the first fold
(This is the second time I send this, as the first message apparently did not
make it)
Dr. Peter Voigt, 30.09.2010 14:42:
If there are no other users out there with comparable problems I could
give the ZIP-installer a try under:
http://www.enterprisedb.com/products/pgbindownload.do
There is a f
Fujii Masao ha scritto:
On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex
wrote:
- why in my tests, _whitout_ common direcotory, master and slave
keep in sync also if I shutdown slave, add (in my last tests)
something about 100k record (although little ones) on the master
and then afte
For the benefit of the list, I've raised this issue with the people
who supply the installer technology, as I can't see any reason why our
code would get this wrong.
On Thu, Sep 30, 2010 at 9:53 PM, Dr. Peter Voigt wrote:
> Dave Page writes:
>
>> A couple of questions for you Peter (and thanks f
2010/9/30 Vincenzo Romano :
> 2010/9/30 Tom Lane :
>> Vincenzo Romano writes:
>>> create or replace function session_init()
>>> returns void
>>> language plpgsql
>>> as $body$
>>> declare
>>> t text;
>>> begin
>>> select valu into t from session where name='SESSION_ID';
>>> if not found then
On Thu, Sep 30, 2010 at 7:29 PM, Willy-Bas Loos wrote:
> One thing that i think works is to create a table from your results.
> That is, if your result is not one big chunk in one row that won't fit
> in memory, but lots of rows.
On second thought, that helps for the scenario where your client
lo
On Thu, Sep 30, 2010 at 17:45, Turner, John J wrote:
>
> It sounds like I'm in quite a fix here. If PGXS is currently a no-go in
> Windows, then that renders the temporal extension incompatible with Windows
> since it uses PGXS to install...
It's not entirely a no-go. If you really want it, yo
On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex
wrote:
> - why in my tests, _whitout_ common direcotory, master and slave keep in
> sync also if I shutdown slave, add (in my last tests) something about
> 100k record (although little ones) on the master and then after woke up
> the slave
On 09/30/10 11:58 PM, GOO Creations wrote:
thanks for this tip, but as far as I understand it libpqtypes is not
part of the original lipq libary .
This will result in the same problem as with the Qt libraries, it will
add another dependecy to my plugin, which is not allowed.
take the source
>
> P.s. Glad to see that also in Italy there are PostgreSQL guru ;)
>
Glad to see that more people are using Indian words (Guru) :)
http://en.wikipedia.org/wiki/Guru
Regards,
Jayadevan
DISCLAIMER:
"The information in this e-mail and any attachment is intended only for
the person to whom
Gabriele Bartolini ha scritto:
Ciao Michele,
Ciao ;)
both server (master and standby) need a common directory where
read
and write the wal files?
Not necessarily. You can use for instance scp to ship the WAL file
from the master to the standby using the network.
Thanks for the explain
65 matches
Mail list logo
