Table A : 220 MB
Table B : 120 KB
Yeah figuring out how to write it in pure SQL.
Thanks
On Tue, Nov 11, 2014 at 6:15 AM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Vinay Gupta wrote
> > Please let me know if there is any optimal way to finish this function in
>
Hi,
I need to optimise and aggregate array integer values in a function and i
am doing this by below stored function :
-- type def
CREATE TYPE fun_type AS (
g_id integer,
zip_id_list integer[],
city_id_list integer[],
state_id_list integer[],
lat_long_id_li
Hi,
Is dere any better way we can understand the contents of pg_xlog files. I
am using xlogdump for analysing my xlog contents. Sometimes in my database
server in some particular hours, the pgxlog files generation exceeded than
the expected counts almost 3X than the normal count.
*--- Size of 1
