Dear all,
I installed PgAgent and started its service and successfully scheduled a
backup and got 100% result. Now the same Job is not working even I reinstalled
PgAgent but failed to get result.
Regards,
Abdul Rehman.
Hi,
my standard query (adapted to 1mb size) is:
select
t.spcname as "tablespace"
, pg_get_userbyid(c.relowner) as "owner"
, n.nspname as "schema"
, relname::text as "name"
, pg_size_pretty(pg_total_relation_size(c.oid))::text as "total size"
, case
when c.relkind='i' th
On Mon, Nov 24, 2008 at 3:42 AM, marcin mank <[EMAIL PROTECTED]> wrote:
>>Yes, the figures are like this:
>>* average number of raw inserts / second (without any optimization
>> or previous aggregation): #clients (~ 100 thousand) * #sensors (~ 10)
>> / 6seconds = 166 thousand inserts / seco
On Sun, Nov 23, 2008 at 6:47 PM, Glen Eustace <[EMAIL PROTECTED]> wrote:
>
>> Generally speaking, virtualization allows you to take a bunch of low
>> powered servers and make them live in one big box saving money on
>> electricity and management. Generally speaking, database sers are big
>> powerf
Generally speaking, virtualization allows you to take a bunch of low
powered servers and make them live in one big box saving money on
electricity and management. Generally speaking, database sers are big
powerful boxes with lots of hard disks and gigs upon gigs of ram to
handle terabytes of da
>Yes, the figures are like this:
>* average number of raw inserts / second (without any optimization
> or previous aggregation): #clients (~ 100 thousand) * #sensors (~ 10)
> / 6seconds = 166 thousand inserts / second...
this is average?
166 000 * 20 bytes per record * 86400 seconds per da
On Sun, Nov 23, 2008 at 5:28 PM, Glen Eustace <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I was wondering whether anyone has had any experience running postgresql in
> a vm under ESx. VMware provides significant HA/DR oppurtunities and we
> would like to use it if we can. The DBase would be on a EMC
Alvaro Herrera wrote:
When I saw the manitou-mail.org stuff some days ago I was curious -- how
feasible would it be to host our web archives using a database of some
sort, instead of the current mbox-based Mhonarc installation we use,
which is so full of problems and limitations?
I wondered abou
Hi all,
I was wondering whether anyone has had any experience running postgresql
in a vm under ESx. VMware provides significant HA/DR oppurtunities and
we would like to use it if we can. The DBase would be on a EMC SAN
hosted LUN and the ESx servers would be dual Quad CPU HP DL-380/G5s. At
Daniel Verite wrote:
> Gregory Stark wrote:
>
> > I would be curious to see the average lifespan of threads over time.
>
> I happen to have the mail archives stored in a database, [...]
When I saw the manitou-mail.org stuff some days ago I was curious -- how
feasible would it be to host ou
On 23/11/2008 20:58, Alvaro Herrera wrote:
> How about getting a new version of the world map showing developer's
> location?
Cool! Definitely +1 if we can show contributors to the list generally,
not just developers.
Ray.
--
Raym
Tom Lane wrote:
> FWIW, this project has always been pretty diversified geographically;
> we've had major contributors in Russia, Japan, and Australia for as far
> back as I can remember, not just Europe and the Americas. I think there
> are more people now, but I'm not convinced that the distrib
Gregory Stark wrote:
> I would be curious to see the average lifespan of threads over time.
I happen to have the mail archives stored in a database, so I've
expressed this in SQL and below are some results for hackers and
general, 2007-2008. count is the number of distinct threads whose
o
On Sun, Nov 23, 2008 at 8:43 AM, V S P <[EMAIL PROTECTED]> wrote:
> Thank you very much
> this is exactly what I am looking for
>
> As well as the example provided
> ' case when id=1 then 10 '
>
> - it will work as well.
>
>
> Now just one more question:
> I will not have a lot of values to updat
On Sun, Nov 23, 2008 at 10:01 AM, Ciprian Dorin Craciun
<[EMAIL PROTECTED]> wrote:
> On Sun, Nov 23, 2008 at 3:28 PM, Stephen Frost <[EMAIL PROTECTED]> wrote:
>> * Ciprian Dorin Craciun ([EMAIL PROTECTED]) wrote:
>>> > Even better might be partitioning on the timestamp. IF all access is
>>> > in a
> If you watch the speed, you'll see that the insert
> speed is the
> same, but the scan speed is worse (from 32k to 200).
As I said, I don't know a lot about these things.
But I would like someone to comment on this (so that maybe I will know
something!):
1) I thought the poor insert perfo
Thanks for your info! Please see my observations below.
By the way, we are planning to also try Informix (the time series
extension?)... Do you have some other tips about Informix?
Ciprian Craciun.
On Sun, Nov 23, 2008 at 6:06 PM, V S P <[EMAIL PROTECTED]> wrote:
> While most of my
Craig Ringer <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>> Another idea, I wonder if the project has gone more international and
>> therefore has more traffic at odd hours of the day for everyone.
> I wouldn't be at all surprised if that were the case. Alas, it's not
> possible to analyze
On Sun, Nov 23, 2008 at 3:28 PM, Stephen Frost <[EMAIL PROTECTED]> wrote:
> * Ciprian Dorin Craciun ([EMAIL PROTECTED]) wrote:
>> > Even better might be partitioning on the timestamp. IF all access is
>> > in a certain timestamp range it's usually a big win, especially
>> > because he can move to
"Andrus" <[EMAIL PROTECTED]> writes:
>> There have been a number of index-corruption bugs fixed since 8.1.4 ...
>>
>> In particular, if it's possible that any of these clients abort before
>> committing these insertions, the vacuum race condition bug fixed in
>> 8.1.10 is a pretty likely candidate
While most of my experience with oracle/informix
I would also recommend
a) partitioning on DB level
Put partitions on on separate hard disks, have the system to be
at least dual core, and make the disks to be attached via SCSI
controller (not IDE) for parallel performance.
b) partitioning on a
Thank you very much
this is exactly what I am looking for
As well as the example provided
' case when id=1 then 10 '
- it will work as well.
Now just one more question:
I will not have a lot of values to update (less than a 1000
at a time) -- but the values for col1 will be text that is
up t
> But unfortunately the query speed is not good at all
> because most
> queries are for a specific client (and sensor) in a given
> time
> range...
Maybe I'm wrong, I don't know a lot of these things; but defining the index as
(timestamp, clientid, sensor) instead of (clientid, sensor, timest
* Ciprian Dorin Craciun ([EMAIL PROTECTED]) wrote:
> > Even better might be partitioning on the timestamp. IF all access is
> > in a certain timestamp range it's usually a big win, especially
> > because he can move to a new table every hour / day / week or whatever
> > and merge the old one into
Craig Ringer <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>> Another idea, I wonder if the project has gone more international and
>> therefore has more traffic at odd hours of the day for everyone. It would
>> also
>> mean more long-lived threads with large latencies between messages and
There have been a number of index-corruption bugs fixed since 8.1.4 ...
In particular, if it's possible that any of these clients abort before
committing these insertions, the vacuum race condition bug fixed in
8.1.10 is a pretty likely candidate for your problem.
I changed second statement to
On Sat, Nov 22, 2008 at 05:34:26PM -0500, blackwater dev wrote:
> Is there a datatype in postgres that will automatically update the date when
> the row is updated? I know I can do a timestamp and set the default to
> now() but once the row is inserted, and then edited, I want the column
> updated
On Sat, Nov 22, 2008 at 10:04:48PM -0500, V S P wrote:
> Hello,
> searched documentation, FAQ and mailing list archives
> (mailing list archive search is volumous :-) )
>
> but could not find an answer:
>
> I would like to be able to update
> several rows to different values at the same time
>
>
V S P <[EMAIL PROTECTED]> schrieb:
> Hello,
> searched documentation, FAQ and mailing list archives
> (mailing list archive search is volumous :-) )
>
> but could not find an answer:
>
> I would like to be able to update
> several rows to different values at the same time
>
> In oracle this use
Gregory Stark wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
>> Bruce Momjian <[EMAIL PROTECTED]> writes:
>>> Tom Lane wrote:
So, to a first approximation, the PG list traffic has been constant
since 2000. Not the result I expected.
>>> I also was confused by its flatness. I am findin
30 matches
Mail list logo