Hi Stefan
1 - If you have a fixed data that does not change a lot, like I assume is your
fixed 'map' try implementing in your app the hashtrie method. This looks as
better approach as your query is quite fast. Usually I am starting to query my
queries (or the query planner) when they start to ta
Hi all,
I got 2 complementary functions, which will do opposite things.
1 - CombineStrings(stringarray character varying[]) RETURNS character varying
This one will take as parameter an array of strings and will return a string
with some formatted information inside
2- SplitString2Array(stringtos
Ah, that did the trick, thank you Kevin,
Danny
From: Kevin Martyn
To: idc danny
Cc: "pgsql-performance@postgresql.org"
Sent: Wednesday, December 14, 2011 3:14 PM
Subject: Re: [PERFORM] copy vs. C function
try
host all all 5.0.0.0/8 md5
On W
Hi guys,
A nub question here since I could not figure it out on my own:
I'm using Hamachi to connect different sites into a VPN and their address
always starts with 5.*.*.* - the problem I'm facing is that I cannot make the
access restricted to that particular range only.
Currently I got :
host a
Hi everybody,
I know that this group deals with performance but is the only one on which I'm
subscribed, so my apologize in advance for the question.
I want to allow everybody in the world, all IP's, to connect to my server. How
do I accomplish that? Definitely, it's not a good solution to ente
Hi everybody,
I'm fairly new to PostgreSQL and I have a problem with
a query:
SELECT * FROM "LockerEvents" LIMIT 1 OFFSET
1099
The table LockerEvents has 11 Mlillions records on it
and this query takes about 60 seconds to complete.
Moreover, even after making for each column in the
table
