Here is the basic structure - is the gist index significant?:
CREATE UNLOGGED TABLE foo (
as_of_date daterange NOT NULL,
customer_id integer,
bunch_of_fields_here);
ALTER TABLE ONLY foo
ADD CONSTRAINT foo_as_of_date_excl EXCLUDE USING gist (customer_id WITH
=, as_of_date WITH &&);
Hi,
Am 06.02.2018 um 08:24 schrieb Michael Krüger:
create or replace function reports.generic_query(_sql text)
RETURNS SETOF record
LANGUAGE 'plpgsql'
PARALLEL SAFE
COST 100
there is an other parameter, parallel_setup_cost, with default = 1000. I
think, you should set this parameter
Dear community,
I need a bit of advice on parallel query execution.
I have a table with roughly 2 million rows in it. These rows are
distributed over a set of IDs. Therefore I can group my rows based on the
ID set.
If I query the table directly like this:
select mediatrunkid,count(*)::numeric fr
On Tue, Feb 06, 2018 at 12:50:56AM -0600, Jeremy Finzel wrote:
> The table I am setting to logged is 32GB with indexes. I see it writing
> WAL files like crazy but after about an hour and a half, it has written out
> some 2500 WAL segments, then it just sits and continues to run as "active",
> but
Hi,
Getting below error—
exec] Flyway (Command-line Tool) v.1.1
[exec]
[exec] Metadata table created: schema_version
[exec] Schema initialized with version: 0
[exec] Flyway (Command-line Tool) v.1.1
[exec]
[exec] ValidationException: Found non-empty schem
We are running:
PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5)
4.7.2, 64-bit
The table I am setting to logged is 32GB with indexes. I see it writing
WAL files like crazy but after about an hour and a half, it has written out
some 2500 WAL segments, then it just sits and
On 5 February 2018 at 19:01, Benjamin Scherrey
wrote:
> One option you should seriously consider is using Docker to containerize
> your postgres installation. The installation thinks it has root access but
> you don't need any rights beyond the standard user role that way you can
> use the standa
One option you should seriously consider is using Docker to containerize
your postgres installation. The installation thinks it has root access but
you don't need any rights beyond the standard user role that way you can
use the standard builds without changes. This assumes you're running under
Lin
On 02/05/2018 12:41 PM, Azimuddin Mohammed wrote:
Hello,
I need to install postgres without root privileges. I have a postgres
user in our companies AD.
Below are my questions n concerns:
1. Is there a website you will refer other the postgres documentation,
the one on postgres website is con
Hello,
I need to install postgres without root privileges. I have a postgres user
in our companies AD.
Below are my questions n concerns:
1. Is there a website you will refer other the postgres documentation, the
one on postgres website is confusing
2. What is the default location of postgress in
Denisa:
1.- Please, do not top-post, it makes seeing what you arereplying to difficult.
2.- Do not reply to several messages in one. Nobody reading this knows
my suggestions.
Having said that, regarding my part:
On Mon, Feb 5, 2018 at 5:54 PM, Denisa Cirstescu
wrote:
> I've tried the version t
Francisco,
I've tried the version that you are proposing before posting this question, but
it is not good as it is removing characters that have ASCII code greater than
255 and those are characters that I need to keep, such as "ă".
SELECT regexp_replace(p_string, E'[^A-Za-z0-9%_]', '',
On Mon, Feb 5, 2018 at 6:34 AM, Denisa Cirstescu <
denisa.cirste...@tangoe.com> wrote:
> Is there a way to specify 2 conditions in regexp_replace?
>
Tom and Francisco both give excellent responses.
I have written a SQL function that achieves this, but I am not happy with
> it because it is har
Denisa Cirstescu writes:
> Is there a way to specify 2 conditions in regexp_replace?
> I need an SQL function that eliminates all ASCII characters from 1-255 that
> are not A-Z, a-z, 0-9, and special characters % and _ so something like:
> SELECT regexp_replace(p_string, E'[' || CHR(1) || '-' ||
Denisa:
On Mon, Feb 5, 2018 at 2:34 PM, Denisa Cirstescu
wrote:
> I need an SQL function that eliminates all ASCII characters from 1-255 that
> are not A-Z, a-z, 0-9, and special characters % and _ so something like:
Are you aware ASCII is a SEVEN bit code ?
And now, why don't you just write t
Hi all,
Is there a way to specify 2 conditions in regexp_replace?
I need an SQL function that eliminates all ASCII characters from 1-255 that are
not A-Z, a-z, 0-9, and special characters % and _ so something like:
SELECT regexp_replace(p_string, E'[' || CHR(1) || '-' || CHR(255) ||
'&&[^A-Za-
Hello Rob,
I already read this.
I have already executed this kind of procedure except with an array.
I don't know why but now it is working :-s
Thank you for your reply :-)
Thomas
2018-02-05 13:16 GMT+01:00 rob stone :
>
>
> On Mon, 2018-02-05 at 11:26 +0100, Thomas Poty wrote:
> > Hello,
On Mon, 2018-02-05 at 11:26 +0100, Thomas Poty wrote:
> Hello,
>
> I m running 9.5.10 on centos 7.
>
> I have a colmun "TestFields", its type is an array of an enum.
>
> I would like to change the type of this column by an array of text.
>
> So i execute -> alter table "controldetailpromoter
Hello,
I m running 9.5.10 on centos 7.
I have a colmun "TestFields", its type is an array of an enum.
I would like to change the type of this column by an array of text.
So i execute -> alter table "controldetailpromoters" alter column
"TestFields" type text[]
The command seems to be correctly
Hi,
I encountered an issue this weeked and was wondering if there is a simple
solution to avoid this specific problem.
A simplified database setup here i three servers, which uses streaming
replication with replication slot on pg10.1
M: a "master" server
C: a hot standby that cascades to ...
S: a
20 matches
Mail list logo