Hope all is well. I have received tremendous help from this list prior and
therefore wanted some more advice.
I bought some new servers and instead of RAID 5 (which I think greatly hindered
our writing performance), I configured 6 SCSI 15K drives with RAID 10. This is
dedicated to /var/lib/pgs
Dne Pá 12. srpna 2011 18:47:24 Merlin Moncure napsal(a):
> On Thu, Aug 11, 2011 at 9:46 AM, Antonin Faltynek wrote:
> > Hi all,
> >
> > I'm testing Streamin replication with one hot standby node and I'm
> > experiencing high delay of hot standby node.
> >
> > When I reach aprox. 50 transactions
Eyal Wilde writes:
> CREATE OR REPLACE FUNCTION test_func(STR text)
> ...
> perform t1.val FROM t1 WHERE
> (COALESCE(rpad(t1.val, 100),'') ) like COALESCE(STR || '%','')
> order by COALESCE(rpad(t1.val, 100), '') using ~<~ LIMIT 5;
[ doesn't use index ]
No, it doesn't. The LIKE index optimizati
Hi,
I encountered a problem while trying to improve the performance of a certain
select query I have made.
here is a simplified code for the function I am using
CREATE OR REPLACE FUNCTION test_func(STR text)
RETURNS integer AS
$BODY$
begin
insert into plcbug(val) values('begin time before perfor
Igor,
thank you , my tests showed better performance against the larger summary
tables when I splited the index for datasource_id & datex , I use to have a
composed index.
Regarding that index statistics - should I analyze the tables? I thought
auto vacuum takes care of it.
helen
--
View this
