I can create an alias of a type like:
CREATE DOMAIN myvarchar varchar;
But I can't declare a myvarchar with a variable size, eg "mycolumn
myvarchar(42)" and from what I've read this is the way it DOMAIN is supposed to
work so I can't do it that way.
Is there a way to define myvarchar the way I
Hello
I worked with 80K float fields without any problem.
There are possible issues:
* needs lot of memory for detoast - it can be problem with more parallel
queries
* there is a risk of possible repeated detost - some unhappy usage in
plpgsql can be slow - it is solvable, but you have to ident
Uninstall postgres. Reset windows socket.
Go to command prompt ---> */netsh winsock reset/*
Now you should be able to install the postgres succesfully. Good Luck!!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Postgres-9-3-Installation-Problems-Windows-7-64-Bit-Pro-t
Hi,
I just stumbled upon this article from 2012 [1], according to which
(emphasis mine):
Window functions offer yet another way to implement pagination in SQL. This
is a flexible, and above all, standards-compliant method. However, only SQL
Server and the Oracle database can use them for a pipeli
Would 10K elements of float[3] make any difference in terms of read/write
performance?
Or 240K byte array?
Or are these all functionally the same issue for the server? If so,
intriguing possibilities abound. :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Is-it-re
On Fri, Feb 14, 2014 at 11:26 AM, Reece Hart wrote:
> Is there a way to automatically refresh all materialized views, preferably
> in order of dependendency?
>
> I should be able to chase pg_depends entries to create this ordering, right?
yeah -- you could do this with some gymnastics and some dy
Is there a way to automatically refresh all materialized views, preferably
in order of dependendency?
I should be able to chase pg_depends entries to create this ordering, right?
Thanks,
Reece
>We are in the process of talking about this:
> http://www.postgresql.org/message-id/86fvnm5t44@jerry.enova.com
> I know of no tool currently available.
Thank you, for the reply. I think, my case might be a little bit different.
I am working with several clusters and I find sometimes pg_hb
On Fri, Feb 14, 2014 at 07:28:38AM -0800, salah jubeh wrote:
> Hello,
>
> I am looking for a tool that could help me in analyzing the pg_hab.conf file.
> For example , detecting duplicates, unused entries, and overlaping entries.
We are in the process of talking about this:
http://www.po
Hello,
I am looking for a tool that could help me in analyzing the pg_hab.conf file.
For example , detecting duplicates, unused entries, and overlaping entries.
Regards
On Fri, Feb 14, 2014 at 10:08 AM, Martin Terjan wrote:
> Dear all,
>
> Using Postgresql 9.3. on Windows x64.
>
> I had streaming replication set up from master to slave, but the slave
> shut down and became out of sync with the master. So... I tried to set it
> back up, without success.
>
> I the
Dear all,
Using Postgresql 9.3. on Windows x64.
I had streaming replication set up from master to slave, but the slave
shut down and became out of sync with the master. So... I tried to set
it back up, without success.
I then checked the *master* log and, although the server seems to be
wor
12 matches
Mail list logo