me values are an order of magnitude more complicated than
people expect.
> Shouldn't this is an optimization handled by the database
> so the user doesn't need to hand optimize these differences?
Sometimes "d >= '1900-01-01'" and "EXTRACT(year from d) >
This isn't true. IBMs IPS series controllers can the checked and configured
via the ipssend utility that works very well in 2.6.x LINUX.
"Scott Marlowe" wrote:
>On Thu, Dec 24, 2009 at 11:09 AM, Richard Neill wrote:
>>
>>
>> Jeremy Harris wrote:
>>>
>>> On 12/24/2009 05:12 PM, Richard Neill w
On Sun, 2009-11-01 at 18:53 +0200, Shaul Dar wrote:
> I am aware of the TOAST mechanism (actually complained about it in
> this forum...). The text fields I have are below the limits that
> trigger this mechanism,
Have you proved somehow that compressing tiny values has any value?
> and also I m
On Mon, 2009-10-05 at 09:37 -0400, Jean-David Beyer wrote:
> Robert Haas wrote (in part):
> > Also, I'd just like to mention that vi is a much better editor than
> > emacs.
> That is not my impression. I have used vi from when it first came out (I
> used ed before that) until about 1998 when I firs
> Maybe - if the only thing the server is running is PostgreSQL. Show of
> hands - how many users who ONLY install PostgreSQL, and use a bare
> minimum OS install, choosing to not run any other software? Now, how
> many people ALSO run things like PHP, and require software more
> up-to-date tha
On Sun, 2009-10-04 at 10:05 -0400, Mark Mielke wrote:
> On 10/01/2009 03:44 PM, Denis Lussier wrote:
> > I'm a BSD license fan, but, I don't know much about *BSD otherwise
> > (except that many advocates say it runs PG very nicely).
> > On the Linux side, unless your a dweeb, go with a newer, popu
> Also, based on what I've seen on this list rather than personal
> experience, you might want to give more thought to your storage than to
> CPU power. The usual thrust of advice seems to be: Get a fast, battery
> backed RAID controller. "Fast" does not mean "fast sequential I/O in
> ideal conditi
connect from a simple Java application (without any of the app
server overhead) otherwise you have no idea who/what you are measuring
[unless your a J2EE guru].
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.openg
t certainly wrong about this; think "syslog"
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
---(end of broadcast)---
TIP 6: explain analyze is your friend
> 0
UNION
SELECT
'INDEX:' || relname,
(idx_blks_read + idx_blks_hit) AS heap_hits,
ROUND(((idx_blks_hit)::NUMERIC / (idx_blks_read + idx_blks_hit) * 100),
2)
FROM pg_statio_user_tables
WHERE (idx_blks_read + idx_blks_hit) > 0
--
Adam Tauno Williams, Network & Systems Administrato
e "ipcs" to show allocated shared memory segments.
One of the better articles on LINUX & memory management -
http://virtualthreads.blogspot.com/2006/02/understanding-memory-usage-on-linux.html
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://w
> > Isn't that the point of the documentation? I mean, if the existing,
> > official manual has been demonstrated (through countless mailing list
> > help requests) to not sufficiently explain a given topic, shouldn't
> > it be revised?
Or it proves that no one bothers to read the docs.
> > One
ocks it for all other users.
This isn't true; the mode of a file open is up to the application.
Possibly lots of Windows applications are stupid or sloppy in how they
manage files but that isn't a flaw in NTFS.
--
Adam Tauno Williams, Network & Systems Administrato
0 530m 71m 59m R 10 1.2 0:50.71 postmaster
> 10195 postgres 15 0 536m 84m 66m S6 1.4 1:11.72 postmaster
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
sand object persistence systems out there, not
much to be gained from re-inventing the wheel.
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
---(e
of classes that are similar but not the same. They all
> have attributes/properties (type is probably String), e.g. (in pseudo
> code):
Use table inheritance.
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - htt
> I’m having this very disturbing problem. I got a table with about
> 100,000 rows in it. Our software deletes the majority of these rows
> and then bulk loads another 100,000 rows into the same table. All this
> is happening within a single transaction. I then perform a simple
> “select count(*)
You get
logging, transactions, and other features thrown in.
http://www.xmlblaster.org/xmlBlaster/doc/requirements/contrib.replication.html
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
On Fri, 2007-06-22 at 02:32 -0400, Greg Smith wrote:
> On Thu, 21 Jun 2007, Scott Marlowe wrote:
>
> > Generally I agree, however, how about a first switch, for beginner /
> > intermediate / advanced.
>
> You're describing a perfectly reasonable approach for a second generation
> tool in this a
ec2.html
http://www.postgresql.org/docs/8.0/interactive/monitoring-stats.html
Also just trolling on this list is useful.
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
---
material. You need to
do the slow slogging work of site/application specific optimization and
tuning; that is where you will find significant performance
improvements.
-
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http:
21 matches
Mail list logo
