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
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-
Ah, that did the trick, thank you Kevin,
Danny
From: Kevin Martyn kevin.mar...@enterprisedb.com
To: idc danny idcda...@yahoo.com
Cc: pgsql-performance@postgresql.org pgsql-performance@postgresql.org
Sent: Wednesday, December 14, 2011 3:14 PM
Subject: Re
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
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
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