The problem is that the uniqueness check apparently increases the serial
counter and hence I burn through the bigint IDs much faster. It's a waste for
100m+ records...
It's a little hidden but
http://www.postgresql.org/docs/current/static/functions-sequence.html
Per the last sentence, upda
Hi,
Is it possible to use an index for like queries on a citext column?
I'm using pg 8.4.1 on windows - with no changes to the default configuration.
For example:
CREATE TABLE test ( citext citext NOT NULL );
INSERT INTO test select md5(random()::text) FROM generate_series(0, 100, 1);
CREATE
Is the pljava.so file included in the PostgreSQL 8.4 binary file for Solaris 10
x86 64-bit? If not, where can I go to download this library file? If so, what
would cause it to not install during the installation process?
Thanks,
Sandra Arnold
Sr. DBA
DOE/OSTI
Oak Ridge, TN
On Mon, Sep 21, 2009 at 4:03 PM, Scot Kreienkamp wrote:
> On the contrary, we've been running PG in production for years now under
> VMWare. Same with MSSQL. We've never had any problems. Less so than an
> actual physical machine actually since we can move the server to different
> physical
In response to Merlin Moncure :
> On Mon, Sep 21, 2009 at 4:03 PM, Scot Kreienkamp wrote:
> > On the contrary, we've been running PG in production for years now under
> > VMWare. Same with MSSQL. We've never had any problems. Less so than an
> > actual physical machine actually since we can
Hi!
What I'm trying to do is to insert some data from a sql file into a postgres
DB by calling the ant task. My problem is that I can't get special
characters (even if they can be represented by the standard ASCII charset,
such as ä, ö, ü, é, etc.) to be inserted correctly.
When I check the D
> Is it possible to use an index for like queries on a citext column?
> I'm using pg 8.4.1 on windows - with no changes to the default configuration.
>
> For example:
>
> CREATE TABLE test ( citext citext NOT NULL );
> INSERT INTO test select md5(random()::text) FROM generate_series(0, 100,
>
Scott Marlowe wrote:
On Mon, Sep 21, 2009 at 11:09 AM, Alan Hodgson wrote:
On Monday 21 September 2009, Christian Koetschan
wrote:
Is everything I insert into mycolA and mycolB stored twice, or
is there something like a pointer/reference from mycolA to the things
stored in mycolB?
It's stor
Hi,
I've used mysql for sometime now, and I'd like to broaden my db
knowledge/experience to include postgresql. Can anyone recommend any books
or other resources that could help me along? Thanks.
-Dan
--
View this message in context:
http://www.nabble.com/Resources-for-learning-PostgreSQL-tp25
On Tue, Sep 22, 2009 at 10:43:09AM -0700, dan06 wrote:
>
> Hi,
>
> I've used mysql for sometime now, and I'd like to broaden my db
> knowledge/experience to include postgresql. Can anyone recommend any books
> or other resources that could help me along? Thanks.
The PostgreSQL website has excel
Tore Halvorsen escribió:
> Hi,
>
> Is it possible to use an index for like queries on a citext column?
> I'm using pg 8.4.1 on windows - with no changes to the default configuration.
>
> For example:
>
> CREATE TABLE test ( citext citext NOT NULL );
> INSERT INTO test select md5(random()::text)
On Tue, 2009-09-22 at 09:10 -0400, Arnold, Sandra wrote:
> Is the pljava.so file included in the PostgreSQL 8.4 binary file for
> Solaris 10 x86 64-bit? If not, where can I go to download this
> library file? If so, what would cause it to not install during the
> installation process?
pljava is
On Tue, Sep 22, 2009 at 8:49 PM, Alvaro Herrera
wrote:
> Tore Halvorsen escribió:
>> Hi,
>>
>> Is it possible to use an index for like queries on a citext column?
>> I'm using pg 8.4.1 on windows - with no changes to the default configuration.
>>
>> For example:
>>
>> CREATE TABLE test ( citext ci
I've have set the parameter in my postgresql.conf file and have restarted
postgres.
When reviewing the log file I am finding that all of the statements are being
logged (0.108 ms)?
Is there some other parameter that I have missed?
log_min_duration_statement = 1000 # -1 is disab
Tore Halvorsen writes:
> On Tue, Sep 22, 2009 at 8:49 PM, Alvaro Herrera
> wrote:
>> Tore Halvorsen escribió:
>>> Is it possible to use an index for like queries on a citext column?
>> Hmm, I think this needs one of the *_pattern_ops indexes. I'm not sure
>> if you can use the builtin ones with
Chris Barnes writes:
> I've have set the parameter in my postgresql.conf file and have restarted
> postgres.
> When reviewing the log file I am finding that all of the statements are being
> logged (0.108 ms)?
Perhaps you also set log_statement = all, or some other reason that
would cause them
I checked and this is the only refererences. Were usng 8.3.3.
#log_statement = 'none' # none, ddl, mod, all
#log_statement_stats = off
> To: compuguruchrisbar...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Logging statements longer than 1000ms doe
Arnold, Sandra wrote:
Is the pljava.so file included in the PostgreSQL 8.4 binary file for
Solaris 10 x86 64-bit? If not, where can I go to download this
library file? If so, what would cause it to not install during the
installation process?
pljava is a mess. you either use GCJ which is
On Tue, 2009-09-22 at 13:35 -0700, John R Pierce wrote:
> Arnold, Sandra wrote:
> > Is the pljava.so file included in the PostgreSQL 8.4 binary file for
> > Solaris 10 x86 64-bit? If not, where can I go to download this
> > library file? If so, what would cause it to not install during the
> >
Grzegorz Jaśkiewicz wrote:
pgadmin does it pretty nicely:
http://pgadmin.org/images/screenshots/pgadmin3_macosx.png
As shown in the mackintosh version, it is a very nice and helpful feature!
I have pgadmin 1.2.0 for PostgreSQL 8.0.15 on i686-pc-linux-gnu,
compiled by GCC gcc (GCC) 3.3.2.
On 22/09/2009 21:48, Emi Lu wrote:
> Grzegorz Jaśkiewicz wrote:
>> pgadmin does it pretty nicely:
>> http://pgadmin.org/images/screenshots/pgadmin3_macosx.png
>
>
> As shown in the mackintosh version, it is a very nice and helpful feature!
>
>
> I have pgadmin 1.2.0 for PostgreSQL 8.0.15 on i68
Hello,
I looked for log_statement and it appears to be off? Strange.
#log_statement = 'none'
#log_statement_stats = off
> To: compuguruchrisbar...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Logging statements longer than 1000ms doesn't appear
> to work
>
Sometimes, your current postgresql.conf might not be in sync with server
settings, for various reasons. I'd suggest looking at the output of:
select name, setting, source from pg_settings where name like E'log\\_%';
Best regards,
On Wed, Sep 23, 2009 at 3:13 AM, Chris Barnes <
compuguruchrisbar.
On Mon, 21 Sep 2009, Tom Duffey wrote:
Does anyone with a better understanding of PostgreSQL and VMWare know if this
is an unreliable setup for PostgreSQL? I see things like "NFS" and "VMWare"
and start to get worried.
PostgreSQL requires one simple guarantee: that when the database writes
On Tue, Sep 22, 2009 at 3:55 PM, Gurjeet Singh wrote:
> Sometimes, your current postgresql.conf might not be in sync with server
> settings, for various reasons. I'd suggest looking at the output of:
>
> select name, setting, source from pg_settings where name like E'log\\_%';
Or
psql dbname
sho
The PostgreSQL website has excellent documentation (second only to
php.net). If you already know MySQL, then you're 2/3 of the way there.
You just need to get used to the quirks of PostgreSQL.
A more accurate statement would be "You just need to learn where the
quirks you've picked up by usi
I have database backup schema+data in text (non-compressed) format.
Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
I run it with "psql http://www.postgresql.org/mailpref/pgsql-general
Le mardi 22 septembre 2009 à 22:48:57, Emi Lu a écrit :
> Grzegorz Jaśkiewicz wrote:
> > pgadmin does it pretty nicely:
> > http://pgadmin.org/images/screenshots/pgadmin3_macosx.png
>
> As shown in the mackintosh version, it is a very nice and helpful feature!
>
>
> I have pgadmin 1.2.0 for Post
28 matches
Mail list logo
