On Fri, Feb 8, 2013 at 02:52:37PM -0600, Jon Nelson wrote:
> I was wondering if somebody could clear up how tablespaces are used.
> Let's say I have three classes of storage:
> - ramdisk (tmpfs)
> - SSD
> - spinning rust
>
> Furthermore, let's say I'd like to be able to tell postgresql to
> prefe
On Thu, Feb 14, 2013 at 9:35 AM, Nicolas Charles
wrote:
> Hello,
>
> I've been struggling to understand what's happening on my databases/query
> for several days, and I'm turning to higher mind for a logical answer.
>
> I'm dealing with a fairly large database, containing logs informations, that
>
On Mon, Feb 11, 2013 at 4:29 PM, Will Platnick wrote:
> We will probably tweak this knob some more -- i.e., what is the sweet spot
> between 1 and 100? Would it be higher than 50 but less than 100? Or is it
> somewhere lower than 50?
>
> I would love to know the answer to this as well. We have a s
On Fri, Feb 15, 2013 at 11:26 AM, Josh Berkus wrote:
> On 02/14/2013 08:47 PM, Scott Marlowe wrote:
>> If you run your benchmarks for more than a few minutes I highly
>> recommend enabling sysstat service data collection, then you can look
>> at it after the fact with sar. VERY useful stuff both
On 02/14/2013 08:47 PM, Scott Marlowe wrote:
> If you run your benchmarks for more than a few minutes I highly
> recommend enabling sysstat service data collection, then you can look
> at it after the fact with sar. VERY useful stuff both for
> benchmarking and post mortem on live servers.
Well,
On Fri, Feb 15, 2013 at 1:00 AM, Nicolas Charles
wrote:
> On 14/02/2013 20:27, Jeff Janes wrote:
>>
>> On Thu, Feb 14, 2013 at 7:35 AM, Nicolas Charles
>> wrote:
>>>
>>> It contains 11018592 entries, with the followinf patterns :
>>> 108492 distinct executiontimestamp
>>> 14 distinct nodeid
>>>
Hello Kevin,
not updating every row which doesn't need the update solved the problem!
Your query took only 1 minute. :)
Thank you so much for the fast response, have a great weekend!
PS: When you switch to "TEXT" on the explain URL you can see the final
runtime which was 66 minutes with the origi
Florian Schröck wrote:
> UPDATE BackupFiles
> SET nTapeNr=0, nAFIOCounter=0, nBlockCounter=0,
> cStatus='NEW'::StatusT, bOnSetBlue=false,
> bOnSetYellow=false, nLastBackupTS= '0001-01-01 00:00:00'
> WHERE cStatus='NEW' OR cStatus='WRITING' OR cStatus='ONTAPE';
>
> Explain analyze:
Hi!
I'm new to this mailinglist and I'm new to postgres as well. It is
about our own backup software (java); we switched the DB from MySQL
to postgres and we need some help.
The backup database holds all files from the server in the database.
On my testing platform th
On 14/02/2013 20:27, Jeff Janes wrote:
On Thu, Feb 14, 2013 at 7:35 AM, Nicolas Charles
wrote:
It contains 11018592 entries, with the followinf patterns :
108492 distinct executiontimestamp
14 distinct nodeid
59 distinct directiveid
26 distinct ruleid
35 distinct serial
How many entries fall
2013/2/13 Matheus de Oliveira
>
> Hi Ali,
>
> That is probably because you did not passed a parameter when defined the
> trigger. You can follow the model at [1]. When creating the trigger, you
> have to use a string parameter with the name of the field with the date
> value used for the partitio
11 matches
Mail list logo
