On 07/08/2016 07:44 AM, vincent wrote:
>
>
> Op 7/8/2016 om 12:23 PM schreef Jean-David Beyer:
>> Why all this concern about how long a disk (or SSD) drive can stay up
>> after a power failure?
>>
>> It seems to me that anyone interested in maintaining an
seconds, my natural gas fueled backup
generator picks up the load very quickly.
Am I overlooking something?
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key:166D840A 0C610C8B Registered Machine 1935521.
/( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
ou insert 273 rows at once, you are doing it
as 273 transactions instead of one?
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key:166D840A 0C610C8B Registered Machine 1935521.
/( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
^^-^^ 09:00:01 up 3 days, 9:57
On 03/03/2013 03:16 PM, Josh Berkus wrote:
> Steven,
>
>> We saw the same performance problems when this new hardware was running
>> cent 6.3 with a 2.6.32-279.19.1.el6.x86_64 kernel and when it was matched
>> to the OS/kernel of the old hardware which was cent 5.8 with
>> a 2.6.18-308.11.1.el5 ke
On 12/05/2012 10:34 AM, Andrea Suisani wrote:
> [sorry for resuming an old thread]
>
> [cut]
>
Question is... will that remove the performance penalty of
HyperThreading?
>>>
>>> So I've added to my todo list to perform a test to verify this claim :)
>>
>> done.
>
> on this box:
>
>> in a
cs. I find that for some tasks involving
global editing, that vi is a lot easier to use. But for most of the things I
do on a regular basis, if find emacs better. So, for me, it is not which is
the better editor, but which is the better editor for the task at hand.
--
.~. Jean-David
with Red Hat, you will need to upgrade to a whole new
distribution whenever you want updated software, which is a much bigger
undertaking.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New J
Linux 5, since they do not add any new features and only correct errors.
CentOS is the same as Red Hat, but you probably get better support from Red
Hat if you need it -- though you pay for it.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A
hunderbird,
perhaps it is a problem in the name server, bind. But wherever it is, it
bugs me.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 13:55:01 up 6 day
tware interrupt.
It also shows disk read, write, and idle time.
Lots of other stuff too.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 14:55:01 up 12
) 549- x4294
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 10:40:01 up 10 days, 21:29, 3 users, load average: 4.19, 4.22, 4.19
--
Sent via pgsql-p
CUPS).
This machine does not crash, but it gets rebooted whenever a new kernel
comes out, and has been up almost a month. It run RHEL5.
I would think Fedora's kernel would probably be OK, but the other bleeding
edge stuff I would not risk a serious server on.
- --
~ .~. Jean-David Be
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
|
- --
~ .~. Jean-David Beyer Registered Linux User 85642.
~ /V\ PGP-Key: 9A2FC99A Registered Machine 241939.
~ /( )\ Shrewsbury, New Jerseyhttp://counter.li.org
~ ^^-^^ 07:55:02 up 5 days, 18:13
chine I ran DB2 on has two 550 MHz processors and 512 Megabytes RAM
running RHL 7.3, and the new machine for postgres has two 3.06 GBYte
hyperthreaded Xeon processors and 8 GBytes RAM running RHEL 5, so a
comparison would be kind of meaningless.
--
.~. Jean-David Beyer Registered Li
of the various
communication paths, and so on.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 11:00:01 up 10 days, 11:30, 2 users, load average: 4.20, 4
t should be charged to the query. And the OS
kernel takes time for IO and stuff as well.
> Of course, it can be easily
> "proved" that this does not happen by simply watching at the CPU
> utilization graphs when executing a query. Nevertheless, those people
> may wonder why (so
ueries, you would get stuck with the join. You would have to
weigh the overall performance issue vs. the performance of this special query.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jersey
Bill Moran wrote:
> In response to Jean-David Beyer <[EMAIL PROTECTED]>:
>
>> Decibel! wrote:
>>> On Nov 18, 2007, at 1:26 PM, gabor wrote:
>>>> hubert depesz lubaczewski wrote:
>>>>> On Fri, Nov 16, 2007 at 10:40:43AM +0100, Gábor Farkas wr
foolish.
Luckily I do not seem to be troubled by the problems experienced by the O.P.
I do know that if I try to use .rpms from other sources, I can get in a lot
of trouble with incompatible libraries. And I cannot upgrade the libraries
without damaging other programs.
--
.~. Jean-Davi
:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:30097919 errors:0 dropped:0 overruns:0 frame:0
TX packets:30097919 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:931924602 (888.7 MiB) TX bytes:931924602 (888.7 MiB
ly skip
that one and wait until RHEL7 comes out in about 3 years.
But somewhere perhaps a reminder of this should be placed where someone like
me would find it, so we would not have to go through this again for someone
else.
--
.~. Jean-David Beyer Registered Linux User 8564
Mario Weilguni wrote:
> Jean-David Beyer schrieb:
>> I am doing lots of INSERTs on a table that starts out empty (I did a
>> TRUNCATE on it). I am not, AFAIK, doing DELETEs or UPDATEs. Autovacuum is
>> on. I moved logging up to debug2 level to see what was going on, and I
Alvaro Herrera wrote:
> Jean-David Beyer wrote:
>> Mario Weilguni wrote:
>
>>> Did you rollback some transactions? It will generate dead rows too - at
>>> least I think so.
>>>
>> No, and the statistics confirm this.
>
> To recap:
>
> -
Andrew Sullivan wrote:
> On Wed, Nov 14, 2007 at 07:12:45AM -0500, Jean-David Beyer wrote:
>> I know there have been rollbacks but I do a REINDEX, CLUSTER, and
>> VACUUM ANALYZE before starting the inserts in question. Do I need to do
>> a VACUUM FULL ANALYZE instead?
>
&
Andrew Sullivan wrote:
> On Wed, Nov 14, 2007 at 07:12:45AM -0500, Jean-David Beyer wrote:
>> I know there have been rollbacks but I do a REINDEX, CLUSTER, and VACUUM
>> ANALYZE before starting the inserts in question. Do I need to do a VACUUM
>> FULL ANALYZE instead?
>
&
Alvaro Herrera wrote:
> Jean-David Beyer wrote:
>
>> How do I reset the counters in pg_stat_database and pg_stat_all_tables?
>> I tried just restarting postgres, but it seems to be saved in the database,
>> not just in the RAM of the server.
>
> There is a function
Merlin Moncure wrote:
> On Nov 13, 2007 9:26 PM, Jean-David Beyer <[EMAIL PROTECTED]> wrote:
>> Merlin Moncure wrote:
>>> what does pg_stat_all_tables say (assuming row level stats are on)?
>> It says stuff like this:
>>
>> relname | seq_scan | seq_tup_r
Merlin Moncure wrote:
> On Nov 10, 2007 1:38 PM, Jean-David Beyer <[EMAIL PROTECTED]> wrote:
>> Tom Lane wrote:
>>> Jean-David Beyer <[EMAIL PROTECTED]> writes:
>>>> I am doing lots of INSERTs on a table that starts out empty (I did a
>>>> TRUN
Andrew Sullivan wrote:
> I'm not a private support organisation; please send your replies to the
> list, not me.
Sorry. Most of the lists I send to have ReplyTo set, but a few do not.
And then I forget.
>
> On Tue, Nov 13, 2007 at 04:57:23PM -0500, Jean-David Beyer wro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andrew Sullivan wrote:
> Please don't drop the list, as someone else may see something.
>
> On Tue, Nov 13, 2007 at 10:06:13AM -0500, Jean-David Beyer wrote:
>> OK. I turned logging from "none" to "mod" an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
> On Nov 10, 2007 1:57 PM, Jean-David Beyer <[EMAIL PROTECTED]> wrote:
>> Joshua D. Drake wrote:
>>> Truncate will not create dead rows. However ROLLBACK will. Are you
>>> getting any duplicate
Joshua D. Drake wrote:
> On Sat, 10 Nov 2007 13:38:23 -0500 Jean-David Beyer
> <[EMAIL PROTECTED]> wrote:
>
>>> Tom Lane wrote:
>>>> Jean-David Beyer <[EMAIL PROTECTED]> writes:
>>>>> I am doing lots of INSERTs on a table that starts
Tom Lane wrote:
> Jean-David Beyer <[EMAIL PROTECTED]> writes:
>> I am doing lots of INSERTs on a table that starts out empty (I did a
>> TRUNCATE on it). I am not, AFAIK, doing DELETEs or UPDATEs. Autovacuum is
>> on. I moved logging up to debug2 level to see w
erstand it if I were doing UPDATEs.
postgresql-8.1.9-1.el5
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 11:15:01 up 18 days, 4:33, 4 users, load avera
getting the
best ones for the problem at hand.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 10:05:01 up 3 days, 2:23, 1 user, load average: 4.10, 4.24, 4.18
Heikki Linnakangas wrote:
> Jean-David Beyer wrote:
>
>> My IO system has two Ultra/320 LVD SCSI controllers and 6 10,000rpm SCSI
>> hard drives. The dual SCSI controller is on its own PCI-X bus (the machine
>> has 5 independent PCI-X busses). Two hard drives are on one SC
Chris Browne wrote:
> [EMAIL PROTECTED] (Jean-David Beyer) writes:
>> But what is the limitation on such a thing? In this case, I am just
>> populating the database and there are no other users at such a time. I am
>> willing to lose the whole insert of a file if something goe
whatever went wrong and start over anyway.
But at some point, disk IO would have to be done. Is this just a function of
how big /pgsql/data/postgresql.conf's shared_buffers is set to? Or does it
have to do with wal_buffers and checkpoint_segments?
--
.~. Jean-David Beyer Regis
0
work_mem = 32768
max_fsm_pages = 4
I have 8GBytes RAM on this machine, and postgreSQL is the biggest memory
user. I set shared_buffers high to try to get some entire (small) tables in
RAM and to be sure there is room for indices.
--
.~. Jean-David Beyer Registered
l extranjero x aca ;)
>
> anyway, back to English ;)
>
> a long shot but...
>
> check if you have any limits set on the host for CPU usage... you may be
> limited to x number of secs / % by the OS scheduler. When you query your
> CPU,
> it will say u are only using 5% or
a separate drive from the tata for the table.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 09:10:01 up 1:37, 4 users, load
re are the *other* risks, such as the place burning to
>> the ground, or getting drowned by a break in the city reservoir that's
>> a couple hundred yards up the hill (but at least I needn't worry about
>
> Invest in sponges. Lots of them. :)
--
.~. Jean-David Beye
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gregory Stark wrote:
> "Jean-David Beyer" <[EMAIL PROTECTED]> writes:
>
>> Gregory Stark wrote (in part):
>>
>>> The extra spindles speed up sequential i/o too so the ratio between
>>> sequential
&
eral
seconds at a time, but that is pretty much of a record.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jerseyhttp://counter.li.org
^^-^^ 06:35:01 up 33 days, 9:57, 0 users, load average:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Willo van der Merwe wrote:
> Jean-David Beyer wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Willo van der Merwe wrote:
>>
>>> Richard Huxton wrote:
>>>
>>>> Willo va
chines from the ISP.
>
Before you get rid of the current ISP, better examine what is going on with
the present setup. It would be good to know if you are memory, processor, or
IO limited. That way you could increase what needs to be increased, and not
waste money where the bottleneck is not.
-
I have this turned on, and if I look at the log, it runs once a minute,
which is fine.
But what does it do? I.e, it runs VACUUM, but does it also do an analyze?
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939
rfectly well (very very little
paging) when it had 4 GBytes RAM. I doubled it because it was cheap at the
time and I was afraid it would become unavailable later. It is usually
between 2/3 and 3/4 used by the cache. When I run IBM DB2 on it, the choke
point is the IO time spent writing the logf
the database.
These drives are about 17 GBytes each, which is enough for the database in
question. (The other two are about 80 GBytes each, which is enough to run
Linux and my other stuff on.)
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A
49 matches
Mail list logo
