hi,
postgresql8.4.7 here.
i checked the pg_stat_user_tables table, and it have a lot of rows
there where the "last_autovacuum" and/or "last_autoanalyze" are null.
does this mean that autovacuum never worked on those tables?
roughly 70% of all the tables have null in those fields..
in those never
2011/6/23 Gábor Farkas :
> hi,
>
> postgresql8.4.7 here.
>
> i checked the pg_stat_user_tables table, and it have a lot of rows
> there where the "last_autovacuum" and/or "last_autoanalyze" are null.
> does this mean that autovacuum never worked on those tables?
>
> roughly 70% of all the tables ha
Hello Gavin,
On Wed, 22 Jun 2011 20:53:19 +1200
Gavin Flower wrote:
> [...]
>This design ensures that: names of towns are unique within a given
>country and >region.
>Note you will still need business logic, in a trigger or some such, to
>ensure that only one town within a given country and
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is on 192.168.2.122. The port 5432 is open, c
On 23/06/2011 08:24, Aritz Dávila wrote:
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is o
On 6/23/11 3:24:12 AM, Aritz Dávila wrote:
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is
2011/6/23 Thom Brown :
> 2011/6/23 Gábor Farkas :
>> hi,
>>
>> postgresql8.4.7 here.
>>
>> i checked the pg_stat_user_tables table, and it have a lot of rows
>> there where the "last_autovacuum" and/or "last_autoanalyze" are null.
>> does this mean that autovacuum never worked on those tables?
>>
>
On Thursday, June 23, 2011 12:24:12 am Aritz Dávila wrote:
> Hi list,
>
> I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
> remote access to this database so after reading I found out that modifying
> pg_hba.conf and postgresql.conf will allow me to access remotely.
>
2011/6/23 Gábor Farkas :
> 2011/6/23 Thom Brown :
>> 2011/6/23 Gábor Farkas :
>>> hi,
>>>
>>> postgresql8.4.7 here.
>>>
>>> i checked the pg_stat_user_tables table, and it have a lot of rows
>>> there where the "last_autovacuum" and/or "last_autoanalyze" are null.
>>> does this mean that autovacuum
On Thursday, June 23, 2011 12:24:12 am Aritz Dávila wrote:
> Hi list,
>
>
> Another strange thing is the following one, if I do the following on the
> database server: psql -h localhost -d database, I grant access but if I do
> the following psql -h 192.168.2.122 -d database on the database serv
I am trying to select nested comments from a table with this structure
CREATE TABLE picture_comments
(
comment_id serial NOT NULL,
user_id integer NOT NULL,
"comment" text NOT NULL DEFAULT ''::text,
comment_date timestamp without time zone NOT NULL DEFAULT now(),
My postgresql instance was last started on Apr21.
In my temp space directory, I have various files that I believe are orphaned.
Given the information below, can I safely rm the files in
/mnt/iscsi/psql_tmp/tmpdata/41099 that are older than Jun 22?
If yes, should these files have been cleaned up b
The result needs to be sorted by date of most recent reply descending
(replying bumps the thread) but also need to be sorted such that the
parent/child relationships are maintained. Multiple replies on the same
level also need to be sorted by date desc.
Getting the parent/child sorting can be a
I remember a few months ago that someone said that the UUID-OSP contrib
module did not work on Windows 64. Is this still a limitation?
Best Regards
Michael GouldIntermodal Software Solutions
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
to_timestamp() returns a TIMESTAMP WITH TIME ZONE
Perhaps an alternative that returns a TIMESTAMP WITHOUT TIME ZONE (which,
BTW, is the default TIMESTAMP)
should be provided. Elsewhere, there is no direct-robust way of parsing
a TIMESTAMP WITHOUT TIME ZONE (which
represesents a "local date-time"
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following settings:
data_directory = '../../
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
not very familiar with the windows version, but I think -D is supposed to point to the data directory which in your later info is
listed as
data_direct
On 2011-06-23 19:15, Reid Thompson wrote:
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
not very familiar with the windows version, but I think -D is supposed to point
to the data directory which in yo
For you reading pleasure :-).
http://schmichael.com/files/schmongodb/Scaling%20with%20MongoDB%20(with%20notes).pdf
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
There is some related discussion here
http://postgresql.1045698.n5.nabble.com/to-timestamp-returns-the-incorrect-result-for-the-DST-fall-over-time-td3327393.html
But it amounts to the same thing: TO_TIMESTAMP() is not apt for dealing with
plain TIMESTAMP
(without time zones).
Hence, there is no f
On 06/23/2011 09:01 AM, hernan gonzalez wrote:
to_timestamp() returns a TIMESTAMP WITH TIME ZONE
Perhaps an alternative that returns a TIMESTAMP WITHOUT TIME ZONE
(which, BTW, is the default TIMESTAMP)
should be provided. Elsewhere, there is no direct-robust way of
parsing a TIMESTAMP WITHOU
On 22/06/11 18.30, David Johnston wrote:
The only (obvious to me) way to really solve the problem - invisibly - is to
allow for table-less unique indexes that multiple tables can share and that
have a pointer to the "source" table for any particular entry in the index.
The other method being disc
> Rather than being not viable, I'd argue that is is not correct. Rather, a
> simple direct cast will suffice:
> '2011-12-30 00:30:00'::timestamp without time zone
>
That works only for that particular format. The point is that, for example,
if I have some local date time
stored as a string in ot
On 06/23/2011 11:40 AM, hernan gonzalez wrote:
Rather than being not viable, I'd argue that is is not correct.
Rather, a simple direct cast will suffice:
'2011-12-30 00:30:00'::timestamp without time zone
That works only for that particular format. The point is that, for
example, i
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver wrote:
> On 06/23/2011 11:40 AM, hernan gonzalez wrote:
>
>>Rather than being not viable, I'd argue that is is not correct.
>>Rather, a simple direct cast will suffice:
>>'2011-12-30 00:30:00'::timestamp without time zone
>>
>>
>> That wo
On 06/23/2011 12:30 PM, hernan gonzalez wrote:
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
mailto:adrian.kla...@gmail.com>> wrote:
On 06/23/2011 11:40 AM, hernan gonzalez wrote:
Rather than being not viable, I'd argue that is is not correct.
Rather, a simple dir
On 06/23/2011 01:07 PM, Steve Crawford wrote:
On 06/23/2011 12:30 PM, hernan gonzalez wrote:
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
mailto:adrian.kla...@gmail.com>> wrote:
On 06/23/2011 11:40 AM, hernan gonzalez wrote:
Rather than being not viable, I'd argue that is is no
On Thu, 2011-06-23 at 13:26 -0700, Adrian Klaver wrote:
> On 06/23/2011 01:07 PM, Steve Crawford wrote:
> > On 06/23/2011 12:30 PM, hernan gonzalez wrote:
> >>
> >>
> >> On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
> >> mailto:adrian.kla...@gmail.com>> wrote:
> >>
> >> On 06/23/2011 11:40 AM
Dne 23.6.2011 20:39, Edoardo Panfili napsal(a):
> I Have the same problem: one ID must be unique.
> Three tables inherits from the same parent table the id column, the ID
> is is defined as:
> id bigint DEFAULT nextval('sequence_name')
> in the parent table.
>
> Can I assume that a sequence ensure
>
>
> Every example here starts, at its core, with to_timestamp. That function
> returns a timestamp *with* time zone so of-course the current timezone
> setting will influence it. Stop using it - it doesn't do what you want.
>
> If you cast directly to a timestamp *without* time zone you can take
> -Original Message-
> >
> > Every feature and function in PostgreSQL is "potentially dangerous"
> > - understanding them and using them correctly is the responsibility
> > of the programmer. Time handling has lots of subtleties that take
> > time to digest
> >
> >
> > Than
> On 22/06/11 18.30, David Johnston wrote:
> > The only (obvious to me) way to really solve the problem - invisibly -
> > is to allow for table-less unique indexes that multiple tables can
> > share and that have a pointer to the "source" table for any particular
entry
> in the index.
> > The other
On Thursday, June 23, 2011 1:42:42 pm hernan gonzalez wrote:
> Fair enough: to_timestamp doesn't do what I want, I must resort to casting.
>
> But it's rather unfortunate that a to_timestamp() function doesnt actually
> parse a "timestamp" (which, is a alias to "timestamp without timezone", at
>
the 2nd example on http://wiki.postgresql.org/wiki/Index_Maintenance
doesn't work on 8.4 or 9.0 unless you add ::text to the arguments of
the two pg_relation_size calls near the beginning.
I don't have wiki edit privs and don't see a way to register so I'm
hoping someone who does can fix that
>
> Possibly:
> test=> select (to_date('30/12/2007','DD/MM/') +
> '00:30'::time)::timestamp;
>timestamp
> -
> 2007-12-30 00:30:00
> (1 row)
>
>
Great, so now I have to capture the date and time portion of the string
separately AND I need to use two parameters i
Greg Smith wrote:
> On 06/21/2011 01:49 AM, CSS wrote:
>> Some raw numbers: We're only looking at a total of about six tables in
>> one db. In total there are going to be well under 10,000 records in ALL
>> tables. That might increase to at most 100,000 in the next few years.
>> Our raw DNS queri
Steve Atkins wrote:
> On Jun 20, 2011, at 10:49 PM, CSS wrote:
>
>> Hello,
>>
>> I couldn't find much information in the archives on this -- perhaps this
>> is a bit of a specialized need, but I was hoping for some input from
>> some experienced postgres admins.
>>
>> I'm moving some DNS servers f
Here:
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
Any comments?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
* Rodrigo E. De León Plicet (rdele...@gmail.com) wrote:
> Any comments?
Sure, they've never bothered to actually look at the data. Consider
that for quite a while Oracle essentially refused to admit that their
could *possibly* be bugs in their system (see: Unbreakable Linux, or
whatever that fool
> http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
>
> Any comments?
Amusing.
"
What kind of support is available if we have a problem? What is their
patching schedule to address exploits and known security defects? If
there is a bug, how responsive is the organi
On 06/23/2011 10:28 PM, Stephen Frost wrote:
Next, PG doesn't even use the same basic technology as Oracle regarding
how transaction isolation and versioning works. Oracle using rollback
segments to store 'old' rows in, while PG uses a Multi-Version
Concurrency Control (MVCC) system. They're fu
On 06/24/2011 09:14 AM, Rodrigo E. De León Plicet wrote:
Here:
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
Any comments?
He's been working with Oracle too long, and forgotten that it's a
database not a career and a lifestyle?
More seriously: it's all a
> > http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgre
> > sql.html
> >
> > Any comments?
>
> Amusing.
>
> "
> What kind of support is available if we have a problem? What is their
> patching schedule to address exploits and known security defects? If
> there is a bug, h
This message has been digitally signed by the sender.
Re___GENERAL__Oracle___PostgreSQL_comparison___.eml
Description: Binary data
Hi-Tech Gears Ltd, Gurgaon, India
Sent using "PostMaster" by QuantumLink Communications
Get your fre
> On 06/24/2011 09:14 AM, Rodrigo E. De León Plicet wrote:
> I'm quite surprised the article didn't mention the importance of having
> "somebody to sue if it goes wrong", which is a comment I often see made
> re Oracle. It's lucky they didn't try to stress that point, because
> evidence of succes
Sorry for the late reply - but I still haven't found a solution,
for example I have a PHP script with 5 consecutive SELECT
statements (source code + problem described again under:
http://stackoverflow.com/questions/6458246/php-and-pgbouncer-in-transaction-mode-current-transaction-is-aborted
) and
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following settings:
data_directory = '../../
I have an application for which data is being written to many disks
simultaneously. I would like to use a postgres table space on each
disk. If one of the disks crashes it is tolerable to lose that data,
however, I must continue to write to the other disks.My specific
concerns are:
1.
On 23/06/11 22.39, Tomas Vondra wrote:
Dne 23.6.2011 20:39, Edoardo Panfili napsal(a):
I Have the same problem: one ID must be unique.
Three tables inherits from the same parent table the id column, the ID
is is defined as:
id bigint DEFAULT nextval('sequence_name')
in the parent table.
Can I a
On Thu, Jun 23, 2011 at 7:14 PM, Rodrigo E. De León Plicet
wrote:
> Here:
>
> http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
>
> Any comments?
That is quite possibly one of the most ignorant opinion pieces I've
ever read. The janitor in Dilbert is significantly
If #1 was solved by using the raid approach, what happens if one of
the disks containing one of my table spaces crashes.
if you are using raid, your tablespaces are on raid volumes comprised of
2 or more drives, any one of those drives may fail, and the full data is
still available. if you
Eduard-Cristian Stefan wrote:
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home
Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following sett
52 matches
Mail list logo
